| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a negative figure as positive
If a number is on the spread sheet as negative, but for another calculation
you want to use the number as a positive - is there anyway to do it? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using a negative figure as positive
Negative number in A1
=A2-A1 will be the same as =A2+A1 with a positive number in A1 -- Regards, Peo Sjoblom "cal_coach_26" wrote in message ... If a number is on the spread sheet as negative, but for another calculation you want to use the number as a positive - is there anyway to do it? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using a negative figure as positive
Use the ABS function:
A1 = -10 =ABS(A1) Returns 10 -- Biff Microsoft Excel MVP "cal_coach_26" wrote in message ... If a number is on the spread sheet as negative, but for another calculation you want to use the number as a positive - is there anyway to do it? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using a negative figure as positive
hi
yes. basicly... a double minus sign. in cell a1.... =-(-5) will display a positive 5. if a1 = -5 and b1 = 5 then in c1 = -a1*b1 = positive 25. if you remove the minus sign in the formula in c1 you have =a1*b1 = negitive 25. the double minus sign comes from the minus sign in a1 and the minus sign in c1. regards FSt1 "cal_coach_26" wrote: If a number is on the spread sheet as negative, but for another calculation you want to use the number as a positive - is there anyway to do it? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using a negative figure as positive
Many thanks - made me think!
"Peo Sjoblom" wrote: Negative number in A1 =A2-A1 will be the same as =A2+A1 with a positive number in A1 -- Regards, Peo Sjoblom "cal_coach_26" wrote in message ... If a number is on the spread sheet as negative, but for another calculation you want to use the number as a positive - is there anyway to do it? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using a negative figure as positive
I use that a lot when I copy and paste special and want to add negative
values, however in a formula Biffs' solution is better -- Regards, Peo Sjoblom "cal_coach_26" wrote in message ... Many thanks - made me think! "Peo Sjoblom" wrote: Negative number in A1 =A2-A1 will be the same as =A2+A1 with a positive number in A1 -- Regards, Peo Sjoblom "cal_coach_26" wrote in message ... If a number is on the spread sheet as negative, but for another calculation you want to use the number as a positive - is there anyway to do it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| negative and positive sums | Excel Worksheet Functions | |||
| Some Positive, Some Negative | Excel Worksheet Functions | |||
| post positive sum as a negative? help! | Excel Worksheet Functions | |||
| IF positive/If negative???? | Excel Worksheet Functions | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
Linear Mode
