Thank you all for help.
Here is the scenario I am trying to fit your cyntax:

If .Value < 30.3 Then
.Offset(0, 1).Value = .Value

if I use this "IF(AND.value(A129.7,A1<30.3)
it gives me an error.

Any idea?
Thanks
syed

Biff Wrote:
Hi!

Try this:

=IF(AND(A129.7,A1<30.3),"yes","no")

Biff

"saziz" wrote in
message ...

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



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