hello there,

this sounds simple but i cannot fathom it out. i want to include an if function that checks if a cell has numbers between a certain range, i.e. 1-4,5-8,9-12 etc and will return a value if true/false etc.

However i can see that there are functions for 'is less than', 'is equals to' but not for 'is between'. The only way I can see to do it is to have a formula like this:

=if(J12<5,"my answer here",if(and(J12<9,J12>4),"my answer here", and so on)

however this makes the formula incredibly long and cumbersome and i'm hoping there is a way round it.

does that make sense. hope you can help

dean