Hi there, I'm hoping that this is the correct Forum for this question!!

I've got a problem with a complex formula and was hoping that some hepful
soul could help me as I'm totally stuck!

Please see below for details:

I need the cell to read from the value in an adjacent cell according to the
following rules:


% logged in
Score

103.9%
5


If C7 is equal to, or less than, 95% then the score will be 0

If C7 is equal to, or greater than, 95.1, but equal to or lower than 98.0,
then the score will be 1

If C7 is equal to, or greater than, 98.1, but equal to or lower than 100.0,
then the score will be 2

If C7 is equal to, or greater than, 100.1, but equal to or lower than 102.0,
then the score will be 3

If C7 is equal to, or greater than, 102.1, but equal to or lower than 103.0,
then the score will be 4

If C7 is equal to, or greater than 103.1, then the score will be 5

The formula I have at the moment (and this is after weeks of trying alone)
is thus€¦.



=IF(C7<95,0)*(IF((OR(C795,C7<98)),1))*(IF((OR(C7 98,C7<100)),2))*(IF((OR(C7100,C7<102)),3))*(IF((O R(C7102,C7<103)),4))*(IF(C7103,5))



€¦.and it keeps giving me the value 0



What do you think??