Multiple if Nested Statement

[slohman]

I need a formula that will check if cell B4, B13, B22 are 0 then it puts 85 in cell B3, then checks if B4, B13, B22 those cells add up to but not greater than 20 will put 75 in B3, then B4, B13, B22 those cells add up to but not greater than 40 will put 65 in B3 and ending with B4, B13, B22 those cells add up to but not greater than 60 will put 65 in B3.

TIA

[Phuocam]

Try this ...

=LOOKUP(SUM(B4,B13,B22),{0,0.1,20.1,40.1,60.1},{0,75,65,65,"???"})

[slohman]

Thanks works fantastic I forgot to put 1 last one if it over 60 I need it to put 45 in B3.

Can you also explain how your formula works?

[slohman]

Can you also explain how your formula works?