Hey All!
Thanks for looking at this - what i need is above my skill set in excel. If this is possible id really appreciate some guidance!
I am looking for a formula that will aid in calculating my pay. I get paid on a tiered scale over a 12-month period. I need to calculate my monthly pay:
I receive 35% of my first $40,000 in billing
70 % of billings between $40,001 and $100,000
and 75% of $100,001+
I think i will need a column for my individual monthly billings, and a 12 month cumulative column to perform the checks?, but i am struggling to put the formula together for the third column.
Any help is greatly appreciated.
Travis.
Bookmarks