|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 21st, 2009, 12:48 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 
|
|
#2
May 21st, 2009, 01:01 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#3
May 21st, 2009, 01:20 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
