View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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