Simple if question??

[Shhhh]

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]

What if they are equal?

Try this:

=MIN(B39:C39)-MAX(B39:C39)

 

[Infinitogool]

Hi

Try
=IF(C39>B39,B39-C39,C39-B39)
Or
=-ABS(B39-C39)

Regards,
Pedro J.