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. 30-100,1-29,etc and will return a value of an arrow up/down. Is that possible?

However i can see that there are functions for 'is less than', is more than, 'is equals to' but not for 'is between'.

example:

in A1 i have 70 and in B1 it will give me an arrow pointing up, in A2 the number is 20 and it will give me an arrow pointing down in B2

I hope it make sense

Thanks