ISNUMBER Tag? - Blank cell help

[PacificQuest]

Afternoon,

P2 = end date
K2 = start date
Z2 = difference between P2 & Z2

then cell AA2 has =Z2-2*20 however this produces a negative figure when no date is added into P2.

How can I keep AA2 showing as a blank cell until P2 has a date entered into it?

Thanks,
PQ

 

[Jonmo1]

Try

=IF(LEN(P2)>0,Z2-2*20,"")

 

[PacificQuest]

Many thanks for the above, it still shows a negative number though

 

[Jonmo1]

What is this part supposed to do

Z2-2*20

Should that be:
Z2 minus the result of 2*20 : then use Z2-40
or
20 * the result of Z2 - 2 : then use (Z2-2)*20

 

[PacificQuest]

Went with the....

=IF(LEN(P2)>0,(Z2-2)*20,"")

...option and it worked great!

Thanks for your help
PQ

 

[PacificQuest]

Hi Again,

I'm not sure what's happened however the result of the below has started to show '-15' in the cell.

I haven't changed anything, and I would like the cell to remain blank if the calculated amount of (AB16-2)*15 is less than 0

=IF(LEN(R16)>0,(AB16-2)*15,"")

Any ideas?
Thanks PQ

 

[Dannyh1]

Hi Try,

=IF(OR(LEN(R16)>0,(AB16-2)*15>=0),(AB16-2)*15,"")

 

[PacificQuest]

Still shows -15

 

[PacificQuest]

Still shows -15

Apologies, and the cell is showing a formula error, however Microsfot help won't give me a clue

 

[Dannyh1]

Hi

when you say formula error, what does it actually say?