Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Change negative amount to positive.
Hi all
I have in cell K2 "30" (without quotes) I have in cell L2 "45" (without quotes) In cell M2 the formula "=K2-L2" (without quotes) The result in M2 is of course -15. The values in K2, and L2, change once a week. Is there a way to show the result of the formula to always show a positive amount, and to react as a positive amount during a 'sort'? I hope this is clear! Thanks George Gee |
#2
|
|||
|
|||
=ABS(K2-L2)
-- Kind regards, Niek Otten Microsoft MVP - Excel "George" wrote in message ... Hi all I have in cell K2 "30" (without quotes) I have in cell L2 "45" (without quotes) In cell M2 the formula "=K2-L2" (without quotes) The result in M2 is of course -15. The values in K2, and L2, change once a week. Is there a way to show the result of the formula to always show a positive amount, and to react as a positive amount during a 'sort'? I hope this is clear! Thanks George Gee |
#3
|
|||
|
|||
Niek Otten
Superb! Many thanks. George Gee Niek Otten wrote: =ABS(K2-L2) "George" wrote in message ... Hi all I have in cell K2 "30" (without quotes) I have in cell L2 "45" (without quotes) In cell M2 the formula "=K2-L2" (without quotes) The result in M2 is of course -15. The values in K2, and L2, change once a week. Is there a way to show the result of the formula to always show a positive amount, and to react as a positive amount during a 'sort'? I hope this is clear! Thanks George Gee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating growth with negative numbers | Excel Worksheet Functions | |||
Compare Negative & Positive Numbers | New Users to Excel | |||
FORMULA TO ADD POSITIVE AND NEGATIVE NUMBERS, REGARDLESS OF SIGN | Excel Discussion (Misc queries) | |||
Finding negative and positive diffrence | Excel Worksheet Functions | |||
can the negative numbers in an IF statement be in a diff color th. | Excel Worksheet Functions |