Help with "if"

B

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
 
S

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 tha
8 then enter "True", otherwise enter "False".

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

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


hope this answers your question

Steve
 
R

Roger Govier

Hi Bob

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

Regards

Roger Govier
 
B

Bob Phillips

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

--

HTH

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