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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP Question 4
INDEX function array causes problem when attempting to use LARGEfunction to sort positive and negati 10
How do I limit formula results to positive only? 4
Formula's 1
Problem with formula for finding last greater than/less than or equal to value 2
excel not recognising numbers containing 0.1calculated by formulas 4
Excel formula help for calculating freight. 2
Retriving column header for non empty cells in a row 2

Top