| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Negative numbers in resulting formula
I have two long formulas each of which produce a negative number as the
result. Using those two numbers in another formula I get a positive number, which is not what I want. What can I do to have the result remain a negative number? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Negative numbers in resulting formula
One approach is to type negative 1 "-1" without the quotes somewhere in your
worksheet. Copy that cell, then highlight your entire result range, paste special multiply. H.T.H. -- when u change the way u look @ things, the things u look at change. "Molly" wrote: I have two long formulas each of which produce a negative number as the result. Using those two numbers in another formula I get a positive number, which is not what I want. What can I do to have the result remain a negative number? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Negative numbers in resulting formula
Yep, just add "*-1" to the end of your formula
"sahafi" wrote in message ... One approach is to type negative 1 "-1" without the quotes somewhere in your worksheet. Copy that cell, then highlight your entire result range, paste special multiply. H.T.H. -- when u change the way u look @ things, the things u look at change. "Molly" wrote: I have two long formulas each of which produce a negative number as the result. Using those two numbers in another formula I get a positive number, which is not what I want. What can I do to have the result remain a negative number? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Negative numbers in an IF formula | Excel Worksheet Functions | |||
| Negative numbers in easy formula getting me down... | Excel Discussion (Misc queries) | |||
| Excel Formula - Add column of numbers but ignore negative numbers | Excel Worksheet Functions | |||
| Formula to calculate only the negative numbers | Excel Worksheet Functions | |||
| Formula for comparing 3 numbers and resulting in the lowest of the | Excel Worksheet Functions | |||
Hybrid Mode
