Hi Everyone - I am hoping you can give me some help with this as I am STUMPED. Here is what I need:
Row 3 Calculates Pension contributions with this formula "=(C3-(134.62*2))*4.95%" That formula goes across for the year, and is totaled in column L.
I need L3 to either hit a Maximum number of 2356.2 or total the sum if it's less than this. I've tried some formulas but gotten into a circular reference number.
I also am having trouble returning the last "remainder" value. Can you help me without the use of a helper row or column?
Any help is greatly appreciated,
Sandi
Bookmarks