#### Imran Azam

##### Board Regular

- Joined
- Mar 15, 2011

- Messages
- 78

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?