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