Ranhge formula

Alex H · Oct 4, 2003

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 · Oct 4, 2003

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

Alex H · Oct 4, 2003

Thanks Don

Don Guillett said:
One way
=if(and(a1>=10000,a1<20000),1,2)

J.E. McGimpsey · Oct 4, 2003

Just another way:

=ABS(A1-15000)<5000