I am trying to assign a rating for example in an audit a certain score between a range will be allocated.
For example a score between 0 and 0.49 would be a 1A and a score between 0.50 would be 1B etc.
I have used the IF function and it seems ok up to a certain number of IF statements. Is there a limit to the number you can do?? If entered this below.
=IF(F169>10,4, IF(F169<=10,3D, IF(F169<8.99,3C, IF(F169<7.99,3B, IF(F169<6.99,3A, IF(F169<5.99,2D, IF(F169<4.99,2C, IF(F169<,3.99,2B E174(F169<2.99,2A, IF(F169<1.99,"1D", IF(F169<1.49,"1C", IF(F169<0.99,"1B", IF(F169<0.49,"1A")))))))))))))
any help would be appreciated. i seem to get an error roughly half way through?
thanks in advance
Sean.
For example a score between 0 and 0.49 would be a 1A and a score between 0.50 would be 1B etc.
I have used the IF function and it seems ok up to a certain number of IF statements. Is there a limit to the number you can do?? If entered this below.
=IF(F169>10,4, IF(F169<=10,3D, IF(F169<8.99,3C, IF(F169<7.99,3B, IF(F169<6.99,3A, IF(F169<5.99,2D, IF(F169<4.99,2C, IF(F169<,3.99,2B E174(F169<2.99,2A, IF(F169<1.99,"1D", IF(F169<1.49,"1C", IF(F169<0.99,"1B", IF(F169<0.49,"1A")))))))))))))
any help would be appreciated. i seem to get an error roughly half way through?
thanks in advance
Sean.