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

[swatsp0p]

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

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



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

[Biff]

Hi!

Try this:

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

Biff

"saziz" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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

Hi!

Try this:

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

Biff

"saziz" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[MrShorty]

Is this a worksheet function or a VBA statement? Your last post makes 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 if

[Dave Peterson]

Hmmmm.

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



swatsp0p wrote:
>
> 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
>
> --
> swatsp0p
>
> ------------------------------------------------------------------------
> swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
> View this thread: http://www.excelforum.com/showthread...hreadid=468308

--

Dave Peterson

[saziz]

Thanks Mr. shorty. That solved my problem.
Syed

[AlfD]

Hi!

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

Alf