jeudi 18 février 2016

If statement excel between a range

I'm trying to create an If statement between a range which is something like:

If $age > 65 and $income = range(90000 to 105000) then 800 - 18.55% else NA

So far I've got

=IF(AND(E4 > 65, E4 <69, F4 > 90000, F4 < 105000), 800 * (1 - 0.1855),"NA")

I am getting NA when I'm trying to get 651.6. Not sure what I'm missing here.

Aucun commentaire:

Enregistrer un commentaire