earn

Hi all. I have been consumed with a dilemma for weeks so I am hoping that someone can help me. Right now, we have employees who either earn sick time or PTO (all-purpose Paid Time Off) depending on how many hours they work in the week. If they work less than 30 hours, they earn .03333 hours...

Hi I'm looking to get help creating a National Insurance Formula which is based on the factors below: you pay National Insurance contributions if you earn more than £162 a week you pay 12% of your earnings above this limit and up to £892 a week the rate drops to 2% of your earnings over £892...

Newb here, I have found similar functions when searching here but nothing which includes the multiple functions I am looking for. See illustration below. Sales Goal $90,000 = Comission 1% of gross profit Sales Goal Bonus $1500 @ $100,000 Sales Cost Of Goods Profit The results in one...

Hi guys, Newbie here, I just want you to help me. Here is the situation, If I was hired last year March 6, 2017, they have given me 5days of leave (SL/VL) per year. How many days I've earned for last year that I can use this year? I just want to compute my leave earn daily by putting a formula...

Good afternoon all I need some help with reworking a commission workbook. The goals in our office have change to the below structure and I am struggling to work out how best to input the formulas to get me to where i need. We sell two products Radio & TV airtime. Commission is based as...

Hello! I am an engineer. although my field is not properly the Informatics, I am pretty good in programming with Excel VBA. In the past I worked in a little company, where I developed a macro that made the company save a big amount of time and money (my macro did in 2 minutes what a person...