IF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to use =IF(A5>5<=10,formula,altformula). No mater what A5 is I
always get false or altformula. Is it possible to use<> in IF statements? If
so, what am I doing wrong?

Thanks for your help!
 
You can't compare items like that. Try something like

=IF(AND(A5>5, A5<=10), formula, altformula)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula question 2
Excel formula, sum the value cell and if empty cell left blank 0
ActiveCell.FormulaR1C1 3
Multi-demensional frequency distribution 4
What am I doing wrong 14
Help with return values on IF/THEN 2
TRUE/FALSE MACRO using Option Buttons 1
formula for double If statements 4

Back
Top