Hi,
I want to add an IF formula to cell where the looked up values are always yes or no. If the answer is yes the target cell returns a value from another cell, if the answer is no the target cell returns 0.
So far I have tried this:
=IF(I32="Yes"),(=I24),(=0)
Thanks for your help.
I want to add an IF formula to cell where the looked up values are always yes or no. If the answer is yes the target cell returns a value from another cell, if the answer is no the target cell returns 0.
So far I have tried this:
=IF(I32="Yes"),(=I24),(=0)
Thanks for your help.