| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula-Positive to Negatie
IF(E139="Bugs Bunny",0,-(K139*0.01))
-- Regards, Peo Sjoblom "Susan" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula-Positive to Negatie
Thank you!
"Peo Sjoblom" wrote: IF(E139="Bugs Bunny",0,-(K139*0.01)) -- Regards, Peo Sjoblom "Susan" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula-Positive to Negatie
Hmmm,
If Bugs Bunny shows up? try this =ABS(IF(E139="Bugs Bunny",0,K139*0.01)) Mike "Susan" wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula-Positive to Negatie
Thank you Mike! Yes, Bugs Bunny, first name that popped into my head : )
"Mike H" wrote: Hmmm, If Bugs Bunny shows up? try this =ABS(IF(E139="Bugs Bunny",0,K139*0.01)) Mike "Susan" wrote: 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 |
| Reply |
| 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) | |||
Hybrid Mode
