Formula based on choice

[RandyD123]

I have this in a cell:

=IF(Y16<>"Y",0,Z16-H16

MY default is "N" and if I don't change the Y/N cell to Y I want the formula to just subtract Z16-H16

N is in all the cells in the Y/N column by default.

How do I write the formula to just minus H16 from Z16 as a default and still have the formula work if I select "Y"?

I'm not sure if I need to provide more info or not?

 

[jbeaucaire]

This should do it:

=(Z16-H16)*(Y16="N")

 

[RandyD123]

I get a "name" error?

 

[jbeaucaire]

Just copy and paste the formula from this thread. Maybe you left the " " out from around the "N"?

 

[RandyD123]

Yep, but now I lose my value when Y is selected!!!

 

[RandyD123]

I'm not sure why my original formula is not doing what is supposed to do and that is minus Z16 from H16 if Y is a N

 

[jbeaucaire]

Perhaps I misunderstand. What is supposed to happen for each of the two options?

Y = ?
N = ?

 

[RandyD123]

Y means I'm turning something on
N means I'm turning something off.

 

[jbeaucaire]

When Y is entered, what should happen?

When N is entered, what should happen?

 

[RandyD123]

jbeaucaire....thanks for taking time to help. The more I look at the formula, it works as intended. As it turns out I just needed the Z16-H16!!! At least that's what I'm thinking at this point. I am going to try this for a few days and see if I'm all set.