Good morning again,
I got help here yesterday and thought that took care of the worksheet that the boss wanted but I was wrong. He wants more formulas and I'm still stuck.
The MS State Tax Credit maximum per person, per year is $500.00. I need to multiply the monthly credit allowance by 12, then multiply that by 25%. This answer must not exceed $500.00. I need this formula for both the male and female. I can't figure out how to make the formula both a SUM and an IF.
(79-D22)*(D20*12*25%max $500)+(83-F22)*(F20*12*25% max $500)
Any chance someone could help me with this one?