Imran Azam
Board Regular
- Joined
- Mar 15, 2011
- Messages
- 103
HI
I am having issues doing an if statement , i seem to get the wrong end result, below is the data i have
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]0.48[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
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?
I am having issues doing an if statement , i seem to get the wrong end result, below is the data i have
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]0.48[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
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?