IF statement error

D

D

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,G11,Q11)>=130,AB11*0.01,0)
What isn't working here?
 
D

Dave F

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 structure: 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
 
P

Pete_UK

Try this amendment:

=IF(SUM(F11,J11,L11)>=105,AB11*0.1,IF(SUM(F11,G11,Q11)>=130,AB11*0.01,0))

Hope this helps.

Pete
 
R

RagDyeR

Its not clear exactly what you want to do.

Do either of these work for you:

=IF(SUM(F11,J11,L11)>=105,AB11*0.1,0)+IF(SUM(F11,G11,Q11)>=130,AB11*0.01,0)

=IF(SUM(F11,J11,L11)>=105,AB11*0.1,IF(SUM(F11,G11,Q11)>=130,AB11*0.01,0))

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

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,G11,Q11)>=130,AB11*0.01,0)
What isn't working here?
 
Top