Adding a fourth formula to spreadsheet

[workingmom434]

Hello,

I have a bonus spreadsheet I am working on that used to calculate by periods and we moved to quarters so I need to add a fourth option to my if statements such as,


=IF(B9=1,(B33+B41+B49+B57)*C268,IF(B9=2,(E33+E41+E49+E57)*C268,(H33+H41+H49+H57)*C268))

Need to add if(b9=4,(k33+k41+k49+k57)*c268

it is telling me I can only do so many formulas. Any help is greatly appreciated.

[Tony Valko]

Try this...

=IF(B9=1,B33+B41+B49+B57,IF(B9=2,E33+E41+E49+E57,IF(B9=4,K33+K41+K49+K57,H33+H41+H49+H57)))*C268

[FDibbins]

IK have a feeling that can be made far simpler, the row is teh same but the column changes.

Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[workingmom434]

This worksheet has so many formulas errors due to a change from 3 periods to four quarters. When you pick the quarter 1, certain fields will calculate down the B row, if you pick quarter 2, the fields will calculate down the E column etc. The formula I am working on in this post is the bottom ones cell a263, c263, e263, h263 & k263 which all formulate off adding certain cells depending on the quarter and times by the quarterly salary.

[FDibbins]

OK still doesnt help much Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[workingmom434]

I did add an attachment to my original posts

[workingmom434]

It's now missing quarter 3 or the if (b9=3

[bebo021999]

Maybe:

Please Login or Register  to view this content.

[Tony Valko]

Did you try the suggestion in post #2?

It does what you asked for.

[workingmom434]

I tried both suggestions, the one in the second post, does not calculate if its b9=3 and the second suggestion is calculating a number but not the correct amount.

[Tony Valko]

Let's try this...

I'm assuming B9 will only contain the numbers 1, 2, 3 or 4.

Fill in the blanks:

If B9=1 sum cells ______

If B9=2 sum cells ______

If B9=3 sum cells ______

If B9=4 sum cells ______