# Thread: formula help Thanks: 0 Likes: 0

1. ## formula help

HI

I am having issues doing an if statement , i seem to get the wrong end result, below is the data i have

 A 1 0.48 2 - 3 0 4 1

now when i do this formula below i should get 175 but for some reason i get 75

=IF(A1="-",0,(IF(A1>0.5,100,IF(A1>0.4,75,IF(A1>0.3,50,0)))+IF(A2="-",0,IF(A2>0.1,100,IF(A2>0.07,75,IF(A2>0.05,50,0)))+IF(A3="",0,IF(A3>4999,100,IF(A3>3999,75,IF(A3>1000,50,0)))+IF(A4="",0,IF(A4<6,100,IF(A4<11,75,IF(A4<15,50,0))))))))

2. ## Re: formula help

Hey try this:

=IF(A1="-",0,IF(A1>0.5,100,IF(A1>0.4,75,IF(A1>0.3,50,0))))+IF(A2="-",0,IF(A2>0.1,100,IF(A2>0.07,75,IF(A2>0.05,50,0))))+IF(A3="",0,IF(A3>4999,100,IF(A3>3999,75,IF(A3>1000,50,0))))+IF(A4="",0,IF(A4<6,100,IF(A4<11,75,IF(A4<15,50,0))))

3. ## Re: formula help

thank you, why was mine not working?
Originally Posted by tyija1995
Hey try this:

=IF(A1="-",0,IF(A1>0.5,100,IF(A1>0.4,75,IF(A1>0.3,50,0))))+IF(A2="-",0,IF(A2>0.1,100,IF(A2>0.07,75,IF(A2>0.05,50,0))))+IF(A3="",0,IF(A3>4999,100,IF(A3>3999,75,IF(A3>1000,50,0))))+IF(A4="",0,IF(A4<6,100,IF(A4<11,75,IF(A4<15,50,0))))

4. ## Re: formula help

Your parenthesis were misplaced, so the nesting was incorrect, easy to do when using multiple IF functions