|
Posted to microsoft.public.excel.misc
|
|
|
If statement
Thanks.
--
JustLearning
"Bernard Liengme" wrote:
=IF($P3480, AB348-P348),IF($U3480,P348-U348,""))
This is read as: If P is greater than zero, return AB minus P
Else if U is great than 0, return P minus U
But is you want "to subtract AB from P" - to quote your message- then use
=IF($P3480, P348-AB348),IF($U3480,P348-U348,""))
You also use the phrase "if column P is filled ", so maybe P could have a
negative value or even a zero value and still be considered "filled", if so
=IF($P348< "", P348-AB348),IF($U348< "",P348-U348,""))
This reads: If P is not empty, then ,,,,, else if U is not empty
Please come back if clarifications are needed
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Cindi" wrote in message
...
I'm trying to do an IF OR statement, but I have something wrong. I
currently
have:
Columns P, U and AB are formatted as a custom date. Column AC
(destination
column) is a whole number.
=IF(OR($P3480,+AB348-P348),"",IF($U3480,+P348-U348,""))
What I'm trying to accomplish is, if column P is filled in then subtract
AB
from P, but if U is filled, then subtract U from P, otherwise leave column
AC
blank.
Can someone please help me?
--
JustLearning
|