IF Statement

[tennisbuck12]

Board,

I have one more IF statement that I can't figure out. It's below
=IF(I9>=0.99,1.5,IF(I9>=0.95,(I9-0.95)/0.04*0.5+1,IF(I9>=0.9,(I9-0.9)/0.05*0.25+0.75,IF(I9>=0.8,(I9-0.8)/10*0.25+0.5,IF(I9<0.8,0)))))*100

The bold part isn't bringing back the right value. I9 is 86.7 and returning 50.2 It should be returning the value 66.8

 

[Joyner]

Re: IF Statement (Should be easy, just not for me)

The formula you have calculates to 50.2 why should it calculate to 66.8, you don't explain that.

 

[tennisbuck12]

Re: IF Statement (Should be easy, just not for me)

The formula you have calculates to 50.2 why should it calculate to 66.8, you don't explain that.

Because its not reading the bolded part of the formula correctly. So here's the orginal formula that I had to transfer so older versions of excel could read it

IFS(I43>=99, 150,I43>=95, (I43-95)/4*50+100,I43>=90, (I43-90)/5*25+75,I43>=80, (I43-80)/10*25+50,I43<80,0)

I43 is the same as I9

 

[Joyner]

Re: IF Statement (Should be easy, just not for me)

Then:

(I9-0.8)/0.1 not (I9-0.8)/10