Excel help

[813615]

Hi guys, would any of you excel genius be able to tell me what formula I need to write for a trigger linked to what distance the race is. I have already managed to sort a cell that counts the furlongs so just want a trigger cell that looks at the furlong cell and says if less than 8 then enter a value of 5, if furlong cell is between 8 and 15 then return a value of 10, if furlong cell is over 15 then return a value of 15. Hope that makes sense, tried with my basic knowledge but it's become a head scratcher hence asking.
Many thanks

[MollyMoo]

Hi.

In the cell where you want your value to appear put the following:

=IF($X$99<8,5,IF(AND($X$99>=8,$X$99<=15),10,IF($X$99>15,15,0)))

This assumes your number of furlongs is in cell $X$99. Change the cell address to your furlong cell address.

Steve.

[813615]

Thank you Steve, I wasn't far off in my attempts just got a few brackets in wrong place so many thanks for your help.
Lee