decklun
Board Regular
- Joined
- Dec 4, 2006
- Messages
- 126
Hi All,
Who is ready for a challenge? I feel like I am coming up with a formula from the movie Good Will Hunting. I am trying to get a formula to work that has 7 logical tests. Here is how I would like it to work....
Test 1, if true Test 2, if false Test 4
Test 2, if true Formula, if false Test 3
Test 3, if true Formula, if false formula
Test 4, if true Test 5, if false Test 7
Test 5, if true Formula, if false Test 6
Test 6, if true formula, if false formula
Test 7, if true formula, if false formula
If I break it down into the 7 tests here is what I would like it to do...
Test 1: IF($C$2<F$2,Test 2,Test 4
Test 2: IF(($B6*SUM($E$4:F$4))*FICA_A<FICA_C,($B6*F$4)*FICA_R,Test 3
Test 3: IF(($B6*SUM($E$4:E$4)+$C6)*FICA_A<FICA_C,(($B6*SUM($E$4:F$4)*FICA_A)-FICA_C)+(($B6*SUM($E$4:F$4))*FICA_M),($B6*F$4)*FICA_M))
After the above, tests 2 and 3 should be complete.
Test 4: IF($C$2=F$2,Test 5,Test 7
Test 5: IF(($B6*SUM($E$4:F$4))*FICA_A<FICA_C,(($B6*F$4)+C6)*FICA_R,Test 6
Test 6: IF(($B6*SUM($E$4:E$4))*FICA_A<FICA_C,((($B6*SUM($E$4:F$4)+$C6)*FICA_A)-FICA_C)+($B6*SUM($E$4:F$4)+$C6)*FICA_M,(($B6*F$4)+$C6)*FICA_M,)
After the above, test 6 is complete
Test 7: IF(($B6*SUM($E$4:F$4))*FICA_A<FICA_C,($B6*F$4)*FICA_R,((($B6*SUM($E$4:F$4))*FICA_A)-FICA_C)+($B6*SUM($E$4:F$4))*FICA_M))))
Which then should complete tests 1, 4, 5 and 7
I am having a hard time because I keep getting the "Error" message in formula. Here is the entire formula (get ready)....
=IF($C$2<F$2,IF(($B6*SUM($E$4:F$4))*FICA_A<FICA_C,($B6*F$4)*FICA_R,IF(($B6*SUM($E$4:E$4)+$C6)*FICA_A<FICA_C,(($B6*SUM($E$4:F$4)*FICA_A)-FICA_C)+(($B6*SUM($E$4:F$4))*FICA_M),($B6*F$4)*FICA_M))IF($C$2=F$2,IF(($B6*SUM($E$4:F$4))*FICA_A<FICA_C,(($B6*F$4)+$C6)*FICA_R,IF(($B6*SUM($E$4:E$4))*FICA_A<FICA_C,((($B6*SUM($E$4:F$4)+$C6)*FICA_A)-FICA_C)+($B6*SUM($E$4:F$4)+$C6)*FICA_M,(($B6*F$4)+$C6)*FICA_M)IF(($B6*SUM($E$4:F$4))*FICA_A<FICA_C,($B6*F$4)*FICA_R,((($B6*SUM($E$4:F$4))*FICA_A)-FICA_C)+($B6*SUM($E$4:F$4))*FICA_M))))
I think that my problem is somehow in the open and shut parenthesis. Or maybe I am unable to skip from test 2 to 4?
If anyone has an ideas I could really use some advice. If this formula is way to confusing (which it is for sure driving me crazy), and more information is needed from me, please let me know!
Thanks for reading!!
decklun
Who is ready for a challenge? I feel like I am coming up with a formula from the movie Good Will Hunting. I am trying to get a formula to work that has 7 logical tests. Here is how I would like it to work....
Test 1, if true Test 2, if false Test 4
Test 2, if true Formula, if false Test 3
Test 3, if true Formula, if false formula
Test 4, if true Test 5, if false Test 7
Test 5, if true Formula, if false Test 6
Test 6, if true formula, if false formula
Test 7, if true formula, if false formula
If I break it down into the 7 tests here is what I would like it to do...
Test 1: IF($C$2<F$2,Test 2,Test 4
Test 2: IF(($B6*SUM($E$4:F$4))*FICA_A<FICA_C,($B6*F$4)*FICA_R,Test 3
Test 3: IF(($B6*SUM($E$4:E$4)+$C6)*FICA_A<FICA_C,(($B6*SUM($E$4:F$4)*FICA_A)-FICA_C)+(($B6*SUM($E$4:F$4))*FICA_M),($B6*F$4)*FICA_M))
After the above, tests 2 and 3 should be complete.
Test 4: IF($C$2=F$2,Test 5,Test 7
Test 5: IF(($B6*SUM($E$4:F$4))*FICA_A<FICA_C,(($B6*F$4)+C6)*FICA_R,Test 6
Test 6: IF(($B6*SUM($E$4:E$4))*FICA_A<FICA_C,((($B6*SUM($E$4:F$4)+$C6)*FICA_A)-FICA_C)+($B6*SUM($E$4:F$4)+$C6)*FICA_M,(($B6*F$4)+$C6)*FICA_M,)
After the above, test 6 is complete
Test 7: IF(($B6*SUM($E$4:F$4))*FICA_A<FICA_C,($B6*F$4)*FICA_R,((($B6*SUM($E$4:F$4))*FICA_A)-FICA_C)+($B6*SUM($E$4:F$4))*FICA_M))))
Which then should complete tests 1, 4, 5 and 7
I am having a hard time because I keep getting the "Error" message in formula. Here is the entire formula (get ready)....
=IF($C$2<F$2,IF(($B6*SUM($E$4:F$4))*FICA_A<FICA_C,($B6*F$4)*FICA_R,IF(($B6*SUM($E$4:E$4)+$C6)*FICA_A<FICA_C,(($B6*SUM($E$4:F$4)*FICA_A)-FICA_C)+(($B6*SUM($E$4:F$4))*FICA_M),($B6*F$4)*FICA_M))IF($C$2=F$2,IF(($B6*SUM($E$4:F$4))*FICA_A<FICA_C,(($B6*F$4)+$C6)*FICA_R,IF(($B6*SUM($E$4:E$4))*FICA_A<FICA_C,((($B6*SUM($E$4:F$4)+$C6)*FICA_A)-FICA_C)+($B6*SUM($E$4:F$4)+$C6)*FICA_M,(($B6*F$4)+$C6)*FICA_M)IF(($B6*SUM($E$4:F$4))*FICA_A<FICA_C,($B6*F$4)*FICA_R,((($B6*SUM($E$4:F$4))*FICA_A)-FICA_C)+($B6*SUM($E$4:F$4))*FICA_M))))
I think that my problem is somehow in the open and shut parenthesis. Or maybe I am unable to skip from test 2 to 4?
If anyone has an ideas I could really use some advice. If this formula is way to confusing (which it is for sure driving me crazy), and more information is needed from me, please let me know!
Thanks for reading!!
decklun