Many thanks for your reply. A great help. Terry Sealey

"Bob Phillips" wrote:

=IF(AND(E9=100,E9<=200), True,False)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"CRICKETERRY" wrote in message
...
In EXCEL I know you can use the IF function with one inequality eg IF E98
THEN....But can you make it do two inequalities at once eg if E9 is
between
100 and 200 THEN... Any help much appreciated