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]

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

[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

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

[Biff]

Hi!

Try this:

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

Biff

"saziz" <saziz.1vgrac_1126893907.3316@excelforum-nospam.com> wrote in
message news:saziz.1vgrac_1126893907.3316@excelforum-nospam.com...
>
> 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]

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" <saziz.1vgrac_1126893907.3316@excelforum-nospam.com> wrote in
message news:saziz.1vgrac_1126893907.3316@excelforum-nospam.com...
>
> 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

[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