View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scoober Scoober is offline
external usenet poster
 
Posts: 82
Default 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