|  | 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! |
|
| |
|
|
