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

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

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

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

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