If Function express negative result

[Allyrd]

Have question regarding If formula.

My basic statement is if, B is greater than A, then B minus A needs to
return a positive value. If B is less than A, I need to have a negative
value shown.

Can I do this all in one cell location?

Thank you for your assistance

 

[Chip Pearson]

Try the following:

=-1*(A1-B1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Bernie Deitrick]

=B1-A1

HTH,
Bernie
MS Excel MVP

 

[Dan E]

Allryd,

Wont the formula
= B - A
do that for you?

B > A -> 10 > 5 -> = 10 - 5 = +5
B < A -> 5 < 10 -> = 5 - 10 = -5

Dan E

 

[Harlan Grove]

Try the following:

=-1*(A1-B1)

Or simply

=-(A1-B1)

but

=B1-A1

is better still.