Multiple If Statements

[BJSax]

I want to create a formula that returns three possible results.
Such as:
Cell C4 can have a result of anywhere from 0 to 30.
I want the adjacent cell, say D4, to return a value of 10 if cell C4 has a value between 20 and 30; return a value of 5 if cell C4 has a value between 10 and 19; and return a value of 0 if cell C4 has a value between 0 and 9.

 

[Michael M]

TRY

=IF(AND(C4>20,C4 < 30),10,IF(AND(C4>10,C4 < 19),5,0))

If the numbers you quote are inclusive use

=IF(AND(C4>=20,C4 < =30),10,IF(AND(C4>=10,C4 < =19),5,0))

 

[FryGirl]

Maybe something like

=LOOKUP(C4,{0,10,20},{0,5,10})

 

[Michael M]

Hi Gail
I like that !!
One for the function library