Excel Formula-Positive to Negatie

[Susan]

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

 

[Peo Sjoblom]

IF(E139="Bugs Bunny",0,-(K139*0.01))


--


Regards,


Peo Sjoblom

 

[Mike H]

Hmmm,

If Bugs Bunny shows up?

try this

=ABS(IF(E139="Bugs Bunny",0,K139*0.01))

Mike

 

[Susan]

Thank you!

IF(E139="Bugs Bunny",0,-(K139*0.01))


--


Regards,


Peo Sjoblom

 

[Susan]

Thank you Mike! Yes, Bugs Bunny, first name that popped into my head : )