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?
=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?
Last edited: