C
Cindi
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($P348>0,+AB348-P348),"",IF($U348>0,+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?
have:
Columns P, U and AB are formatted as a custom date. Column AC (destination
column) is a whole number.
=IF(OR($P348>0,+AB348-P348),"",IF($U348>0,+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?