logic test with nested IF fuctions - help

M

marla

I'm trying to write a logical function with 4 nested IF functions in a cell.
The Excel help menu and a manual I referenced used examples with exact
numbers rather than a series of numbers - which is what I need. Please see
examples below.

IF(H7<5,(F7),IF(H7>=5,(F7*0.9)))
this formula is operational but incomplete for my needs. In the second IF
function, I need not only a "5" but a series of numbers: "5 up to 9" or "5
but less than 10"

Beyond that, I need to add 2 more IF functions after the second, for a total
of 4 IF functions in the cell.
IF(H7<5,(F7),IF(H7>=5 and <10,(F7*0.9),IF(H7>=10 and
<25,(F7*.85),IF(H7>=25,(F7*.80)))))
 
B

bpeltzer

The syntax for the 'and' function is and(condition1,condition2). But since
you won't test for >=5 and <7, for example, unless you've already failed the
test for <5, you really don't need to test again for >=5 so the 'and' isn't
needed:
=if(h7<5,f7,if(h7<10,f7*0.9,if(h7<25,f7*0.85,f7*0.8)))
 

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

Top