How do I keep the cell blank?

S

Scoober

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
 
J

Jacob Skaria

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

If this post helps click Yes
 
D

David Biddulph

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula help please. 3
Keeping cells blank even though formula is input 3
Formula than understands midnight? 26
Hide columns based on row values 2
Transfer a name from one cell to another but leave clear if clear? 3
Count Number of Unique Cells That Don't Have Certain Characters 0
Table Header Cells keep shifting 8
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2

Top