- Joined
- Mar 22, 2016
- Posts
- 4,331
I'm no Excel master, so I apologize if this seems really easy but I honestly don't exactly know how to word my question to where Google will know WTF I'm talking about.
Here's my situation. I have an Excel sheet I'm trying to set up as a personal goal tracker for my fellow employees. The incentive program we have instituted will grant an employee $5.00 for each item completed, past 25, in the month.
So basically, if Billy completes 25 goals, he gets no bonus. But if he completes 26, He gets five bucks. At 27, another $5, and so on. $5 for each additional goal completed after 25.
I have my excel sheet using =counta(A1:A100) and so on to count/display how many goals an employee has completed in a month and its working great. What I would like to do is have another cell next to that, that will display how much an employee will get as a bonus. But I'd like to format it to where it will only display how much they've made and increase by $5 with each new goal they add to the column after 25 goals. If they have completed 25, its blank (or 0, whatever). But if they complete say, 27, the cell displays $10.00. 28 = $15, etc etc etc.
I hope that makes sense, and I apologize if it's really simple, but I just dont know where to start to get this formula, if it's even possible. As an example, I've attached an image with what I would like the sheet to display.
Please halp.
Here's my situation. I have an Excel sheet I'm trying to set up as a personal goal tracker for my fellow employees. The incentive program we have instituted will grant an employee $5.00 for each item completed, past 25, in the month.
So basically, if Billy completes 25 goals, he gets no bonus. But if he completes 26, He gets five bucks. At 27, another $5, and so on. $5 for each additional goal completed after 25.
I have my excel sheet using =counta(A1:A100) and so on to count/display how many goals an employee has completed in a month and its working great. What I would like to do is have another cell next to that, that will display how much an employee will get as a bonus. But I'd like to format it to where it will only display how much they've made and increase by $5 with each new goal they add to the column after 25 goals. If they have completed 25, its blank (or 0, whatever). But if they complete say, 27, the cell displays $10.00. 28 = $15, etc etc etc.
I hope that makes sense, and I apologize if it's really simple, but I just dont know where to start to get this formula, if it's even possible. As an example, I've attached an image with what I would like the sheet to display.
Please halp.