formula help

[Imran Azam]

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

<tbody>
</tbody>

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))))))))

can anyone help please?

 

[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))))

 

[Imran Azam]

thank you, why was mine not working?

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))))

 

[tyija1995]

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