If statement

[APH]

Hi

i have to work out a commission based on cell B8

Is there an easy way of expressinf if B8 > 6500 and B8< 10001?

Thanks
Alex

 

[Frank Kabel]

Hi
try
=IF(AND(B8>6500,B8<10001),"within range","out of range")

 

[APH]

Thanks Frank

Hi
try
=IF(AND(B8>6500,B8<10001),"within range","out of range")