=if(and(a129.7,a1<30.3),"between","not between")
or
=if(and(29.7<a1,a1<30.3),"between","not between")

I think I like the second one. It kind of looks like A1 should be trapped
between the two values.



saziz wrote:

Hi All,
What is the cyntax for "IF" statement

I like to test a cell for a value 29.7 and < 30.3

Thanks for the help.
Syed

--
saziz
------------------------------------------------------------------------
saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350
View this thread: http://www.excelforum.com/showthread...hreadid=468308

--

Dave Peterson