How do I keep the cell blank?
You have missed out the second argument of your OR function.
You presumably intended it to be
=IF(AND(S21="y",R21<"",T21<""),R21*(1-T21)*48,IF(OR(R21="N",R1=""),"",R21*48))
--
David Biddulph
"Scoober" wrote in message
...
Hi,
I have entered this formula in cell U21
=IF(AND(S21="y",R21<"",T21<""),R21*(1-T21)*48,IF(OR(R21="N",),"",R21*48))
But when all the cells around the formula are empty it show a zero. How
can
I keep this cell empty when it is not in use?
Cheers Scott
|