So, I have my base pay in cell B2

Column A runs down the % of the contribution made by me, 6% - 30%

Column B is contribution in dollars, this is base pay * contribution %

Column C is employer contribution, set at 3%, or .03 for calculation purposes

Column D is total contribution, mine + employers

Column E is Yearly contribution - column D * 12

So, I'm assuming my formula would be fv(1+.06)360,D4

That would be 6% interest, 360 months (30 years),D4 (total monthly contributions)

I'm getting a -6 trillion number :)

I'm usually very proficient in excel, so something isn't clicking in my head this morning.

I also have taxes/insurance, dependent care contribution, and HSA contribution, to help come to my actual net paycheck amount, but that isn't the issue at hand.