Thread: Help with "if"
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Bob
 
Posts: n/a
Default Help with "if"

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