Shorter, but perhaps not as clear:
=ABS(A4-7)<=1

--
Dana DeLouis
Win XP & Office 2003


"Bob" wrote in message
...
is there a way of inputing say
=if(a4 is between 6 and 8) so to get a true response and a false
a4 = say 6.5
please help