Thank you for the help. Sorry can't get rid of the N/A, it's required for a
blank field.
--
JustLearning


"Fred Smith" wrote:

In my opinion, the best way to handle N/A's is not to have them in the first
place. I would fix the formula that currently generates the N/A.

Regards,
Fred.

"Fred Smith" wrote in message
...
Try it this way:
=IF($P3480,P348-AB348,IF($U3480,P348-U348,""))

This, as requested "subtracts AB from P". If this isn't really what you
want, then try:
=IF($P3480,AB348-P348,IF($U3480,P348-U348,""))

BTW, plus signs at the beginning of formulae are superfluous.

Regards,
Fred.




"Cindi" wrote in message
...
Im 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 Im 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