How do I keep the cell blank?
 

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

How do I keep the cell blank?
 

=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

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