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

Hi,

The formula below should work -

=IF((AND(B46,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

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

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

--

HTH

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


"Bob" wrote in message
...
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

Thank you

"Steven_Archer" wrote:


Hi,

The formula below should work -

=IF((AND(B46,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

Thank you

"Steven_Archer" wrote:


Hi,

The formula below should work -

=IF((AND(B46,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

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

thank you

"Bob Phillips" wrote:

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

--

HTH

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


"Bob" wrote in message
...
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

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

--
Dana DeLouis
Win XP & Office 2003


"Bob" wrote in message
...
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