IF Statement in action

[Dave]

This is in relation to an established cell containing a
simple formula. Let's say that E6 = $620-$446.16. And
let's say that the "test" formula, in F6, says, =IF
(E6>120<=960,(.15*(E6-120)),""). When I deploy this
formula, I get a blank cell in F6, so therefore the ""
aspect is working. But since the contents of cell E6 are
greater than 120 but less than 960, then I should have
received a mathematical result of 15% times the difference
of E6 and 120. I don't understand why this formula didn't
work in the cell. Please advise and thank you.

 

[dcronje]

use this syntax:


=IF(AND(E6>120,E6<=960),(.15*(E6-120)),""

 

[Norman Harker]

Hi Dave!

You have your condition wrong.

You need:

=IF(AND(E6>120,E6<=960),0.15*(E6-120),"")

If you test your condition:

=E6>120<=960
Returns FALSE

If you test the revised condition:

=AND(E6>120,E6<=960)
Returns TRUE

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.