I have the following formula
=if($I$33="y",1,1-$Q$37) this is in Q44 cell
I need to add if Q37 is empty use Q40
I can't figure out how to write the formula.
What it does now is if there is a y in cell I33 subtract Q37 from Q44, but
now I need to add use Q37 or Q40
--
Louise