Help with "if"

[Bob]

is there a way of inputing say
=if(a4 is between 6 and 8) so to get a true response and a false
a4 = say 6.5
please help

[Steven_Archer]

Hi,

The formula below should work -

=IF((AND(B4>6,B4<8)),"TRUE","FALSE")

Where B4 is the cell where the number is.


So what the formula is saying is if B4 is greater than 6 and less than 8 then enter "True", otherwise enter "False".

This formula will show 6 and 8 as "false". If you want to change it to show 6 and 8 as true change the formula to :

=IF((AND(B4>=6,B4<=8)),"TRUE","FALSE")


hope this answers your question

Steven

[Roger Govier]

Hi Bob

=IF(AND(A4>=6,A4<=8),"true response","false response")

Regards

Roger Govier


Bob wrote:
> is there a way of inputing say
> =if(a4 is between 6 and 8) so to get a true response and a false
> a4 = say 6.5
> please help

[Bob Phillips]

=AND(A4<=6,A4>=8)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob" <[email protected]> wrote in message
news:[email protected]...
> is there a way of inputing say
> =if(a4 is between 6 and 8) so to get a true response and a false
> a4 = say 6.5
> please help

[Bob]

Thank you

"Steven_Archer" wrote:

>
> Hi,
>
> The formula below should work -
>
> =IF((AND(B4>6,B4<8)),\"TRUE\",\"FALSE\")
>
> Where B4 is the cell where the number is.
>
>
> So what the formula is saying is if B4 is greater than 6 and less than
> 8 then enter "True", otherwise enter "False".
>
> This formula will show 6 and 8 as "false". If you want to change it to
> show 6 and 8 as true change the formula to :
>
> =IF((AND(B4>=6,B4<=8)),\"TRUE\",\"FALSE\")
>
>
> hope this answers your question
>
> Steven
>
>
> --
> Steven_Archer
> ------------------------------------------------------------------------
> Steven_Archer's Profile: http://www.excelforum.com/member.php...o&userid=29025
> View this thread: http://www.excelforum.com/showthread...hreadid=487581
>
>

[Bob]

Thank you

"Steven_Archer" wrote:

>
> Hi,
>
> The formula below should work -
>
> =IF((AND(B4>6,B4<8)),\"TRUE\",\"FALSE\")
>
> Where B4 is the cell where the number is.
>
>
> So what the formula is saying is if B4 is greater than 6 and less than
> 8 then enter "True", otherwise enter "False".
>
> This formula will show 6 and 8 as "false". If you want to change it to
> show 6 and 8 as true change the formula to :
>
> =IF((AND(B4>=6,B4<=8)),\"TRUE\",\"FALSE\")
>
>
> hope this answers your question
>
> Steven
>
>
> --
> Steven_Archer
> ------------------------------------------------------------------------
> Steven_Archer's Profile: http://www.excelforum.com/member.php...o&userid=29025
> View this thread: http://www.excelforum.com/showthread...hreadid=487581
>
>

[Bob]

thank you


"Roger Govier" wrote:

> Hi Bob
>
> =IF(AND(A4>=6,A4<=8),"true response","false response")
>
> Regards
>
> Roger Govier
>
>
> Bob wrote:
> > is there a way of inputing say
> > =if(a4 is between 6 and 8) so to get a true response and a false
> > a4 = say 6.5
> > please help
>

[Bob]

thank you

"Bob Phillips" wrote:

> =AND(A4<=6,A4>=8)
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Bob" <[email protected]> wrote in message
> news:[email protected]...
> > is there a way of inputing say
> > =if(a4 is between 6 and 8) so to get a true response and a false
> > a4 = say 6.5
> > please help
>
>
>

[Dana DeLouis]

Shorter, but perhaps not as clear:
=ABS(A4-7)<=1

--
Dana DeLouis
Win XP & Office 2003


"Bob" <[email protected]> wrote in message
news:[email protected]...
> is there a way of inputing say
> =if(a4 is between 6 and 8) so to get a true response and a false
> a4 = say 6.5
> please help