"IF" Statements in Excel??? 3

[RookieDBO]

I've got 2 columns in Excel, each containing "if" statements. The "if" statements are the following.

Column 1 = (IF((BOOKED<SHIP),(SHIP-BOOKED),0))
Column 2 = (IF((SHIP<BOOKED),(BOOKED-SHIP),0))

They both work. I'd like to know if they can be combined in one cell???

Thanks,
RookieDBO

 

[DaleWatson123321]

RookieDBO,

This should work...

=(IF((BOOKED<SHIP),(SHIP-BOOKED),(IF((SHIP<BOOKED),(BOOKED-SHIP),0))))


Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[pjm]

Hiya!

It looks like what you want is the difference between booked and ship but as a positive number?

If that is what you need then just say:

=ABS(BOOKED-SHIP)

If not, then post again with more details

pjm

 

[RookieDBO]

Thanks guys. It worked.

RookieDBO