IF

M

mortgagesrus

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!
 
J

Juan Pablo González

You can't compare items like that. Try something like

=IF(AND(A5>5, A5<=10), formula, altformula)
 
Top