| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
