If statement

APH · Jul 27, 2004

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 · Jul 27, 2004

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

APH · Jul 27, 2004

Thanks Frank

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