Multiple "if greater than, if less than"

[PaisleyFin]

Hi, i'm hoping someone can help me. I'm trying to do a formula to say the following:

If C7 is greater than 0 but less than 336 then 0. If C7 is greater than 335 but less than 671 then 1. If C7 is greater than 67p but less than 1005 then 2...

It goes on up to 10 so is quite long. Can anyone help a struggling simpleton?

Many thanks.

 

[RoryA]

I'd recommend a lookup table as it's easier to maintain. In the first column of the table put the start value of each band (0, 336 etc) and in the second column put the value for the band (0, 1 etc). Then you just need:

=LOOKUP(C7,G1:H10)

for example.

 

[Fluff]

Another option if C7 can never be 0 or less

=INT((C7-1)/335)