Ranhge formula

[Alex H]

Hi

In Excel what's the best way of entering a formula to test if a cell
contents is between eg 10000 and 20000?

Thanks

Alex

 

[Don Guillett]

One way
=if(and(a1>=10000,a1<20000),1,2)

 

[Alex H]

Thanks Don

One way
=if(and(a1>=10000,a1<20000),1,2)

 

[J.E. McGimpsey]

Just another way:

=ABS(A1-15000)<5000