You're getting errors because Excel doesn't know what you're trying to do.
Take a look at your first IF clause. IF statements have the IF-THEN-ELSE
logic structure, and your first IF clause contains "IF the SUM of these three
cells is greater than or equal to 105, THEN AB*.1, ELSE 0" After that you
have more IF clauses, but you've used up your IF THEN ELSE conditions.

Nested IF functions have the structu IF, THEN, ELSE IF, THEN, ELSE IF,
THEN, ELSE

So you need to do something like:
=IF(SUM(F11,J11,L11)=105,AB11*0.1,IF(SUM(F11,G11, Q11)=130,AB11*0.01,0))

Hope that's clear.

Dave

--
Brevity is the soul of wit.


"D" wrote:

I need to take the sum value of several cells and then take another cell and
multiply it. Then with a nested IF, do the same thing with the Sum of
different cells(except one is the same). Keep getting #VALUE! returned.
Here is the formula I am trying:
=IF(SUM(F11,J11,L11)=105,AB11*0.1,0),IF(SUM(F11,G 11,Q11)=130,AB11*0.01,0)
What isn't working here?