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.
Bookmarks