IF statement error
 

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?

IF statement error
 

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?

IF statement error
 

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

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?

IF statement error
 

Thanks, That was awesome. I ended the first IF statement and shouldn't have

"Dave F" wrote:

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?

IF statement error
 

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,G 11,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!
================================================== ===

"D" wrote in message
...
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?