| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula-Positive to Negatie
Hello All,
Need to change a postive to a negatvie Using the formula below, need to get a negative number. EX: 1% of K139 should show as a minus, EX: -2.25, now returning 2.25 If "Bugs Bunny" shows up in column E, a zero should be returned IF(E139="Bugs Bunny",0,K139*0.01) Thank you All |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FORMULA Sorts neg numbers as positive.. | Excel Discussion (Misc queries) | |||
| Formula to stop adding at a positive number | Excel Worksheet Functions | |||
| Cell formula where result to be Positive only | Excel Discussion (Misc queries) | |||
| formula for negative and positive numbers in different columns | Excel Worksheet Functions | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
Threaded Mode
