=IF(AND(S21="y",R21<"",T21<""),R21*(1-T21)*48,IF(R21="N","",IF(R21="","",R21*48)))

If this post helps click Yes
---------------
Jacob Skaria


"Scoober" wrote:

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