Excel Formula-Positive to Negatie

S

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
 
M

Mike H

Hmmm,

If Bugs Bunny shows up?

try this

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

Mike
 
Top