if < and >

[saziz]

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.
Sye

 

[Dave Peterson]

=if(and(a1>29.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.

 

[Biff]

Hi!

Try this:

=IF(AND(A1>29.7,A1<30.3),"yes","no")

Biff

 

[swatsp0p]

You don't tell us what you want to do with the IF statement, but i
would look something like this:

=IF(AND(A1>29.7,A1<30.3),"In Range","Out of Range")

Does this work for you?

Bruc

 

[swatsp0p]

=if(and(a1>29.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.

Dave Peterson

Dave is into bondage? All righty, then. It gets the job done.

 

[saziz]

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(A1>29.7,A1<30.3)
it gives me an error.

Any idea?
Thanks
syed

 

[MrShorty]

Is this a worksheet function or a VBA statement? Your last post make
me think you are referring to a VBA statement which would look like

If .value>29.7 and .value<30.3 then
statement
Else
statement
End i

 

[Dave Peterson]

Hmmmm.

http://www.imdb.com/title/tt0119360/

You don't tell us what you want to do with the IF statement, but it
would look something like this:

=IF(AND(A1>29.7,A1<30.3),"In Range","Out of Range")

Does this work for you?

Bruce

 

[saziz]

Thanks Mr. shorty. That solved my problem.
Syed

 

[AlfD]

Hi!

Not being unkind, but it helps your helpers if you define the proble
and its context as precisely as you can.

Al