|  | Simple if question?? |  | |
| | | Shhhh |  |
| Posted: Sun Aug 10, 2008 10:21 pm Post subject: Simple if question?? |  |
Hello all,
I'm looking for a simple if function that says basically:
IF C39 is greater than B39 then B39-C39... if however B39 is greater than C39 then C39-B39
I'm sure its a fairly simple one but I'm lost.
Any and all help greatly appreciated!
Thanks! |
| |
| | | T. Valko |  |
| Posted: Sun Aug 10, 2008 10:21 pm Post subject: Re: Simple if question?? |  |
What if they are equal?
Try this:
=MIN(B39:C39)-MAX(B39:C39)
-- Biff Microsoft Excel MVP
"Shhhh" <trumpet1120@comcast.net> wrote in message news:f206df49-5e27-45d9-aa4f-1434f4dff531@c58g2000hsc.googlegroups.com...
| Quote: | Hello all,
I'm looking for a simple if function that says basically:
IF C39 is greater than B39 then B39-C39... if however B39 is greater than C39 then C39-B39
I'm sure its a fairly simple one but I'm lost.
Any and all help greatly appreciated!
Thanks! |
|
| |
| | | Infinitogool |  |
| Posted: Sun Aug 10, 2008 10:21 pm Post subject: Re: Simple if question?? |  |
Hi
Try =IF(C39>B39,B39-C39,C39-B39) Or =-ABS(B39-C39)
Regards, Pedro J.
| Quote: | Hello all,
I'm looking for a simple if function that says basically:
IF C39 is greater than B39 then B39-C39... if however B39 is greater than C39 then C39-B39
I'm sure its a fairly simple one but I'm lost.
Any and all help greatly appreciated!
Thanks! |
|
| |
|
|