P
phat al
I need to make a sheet that give totals based on monthly figures from
last year.
Then based on difference between the 2 it will show no increase and no
bonus, or it will show an increase and bonus based on increments $75.
to help I will make one that needs work.
One month Last year the store made 31.82% on it’s money.
The bonus for anything over is $75 per 10% increments.
Ie
0.00% $400
0.10% $475
0.20% $550
0.30% $625
0.40% $700
So this month was over last months, 37.18% so the bonus was $3,975.
What formula do I use to make this calculation shown under % is nothing
but anything over adds up to a relation with $75. added to a base of
$400 every 10%.
This hurt my head trying to get it right and im new to this more
complicated formulas.
Please in advance to anyone who has time to help Thank you
last year.
Then based on difference between the 2 it will show no increase and no
bonus, or it will show an increase and bonus based on increments $75.
to help I will make one that needs work.
One month Last year the store made 31.82% on it’s money.
The bonus for anything over is $75 per 10% increments.
Ie
0.00% $400
0.10% $475
0.20% $550
0.30% $625
0.40% $700
So this month was over last months, 37.18% so the bonus was $3,975.
What formula do I use to make this calculation shown under % is nothing
but anything over adds up to a relation with $75. added to a base of
$400 every 10%.
This hurt my head trying to get it right and im new to this more
complicated formulas.
Please in advance to anyone who has time to help Thank you