Calculating production totals

  • Thread starter Thread starter Cameron
  • Start date Start date
C

Cameron

I am working on a database where I need to take a monthly
production figure add it to the running total for the
year and multiply everything below $67,800 by 50% and
everything above $67,800 by 95%. It would also really be
great if I could somehow reset the annual figure every
year in September. Column A is a date figure so I am
thinking that somehow I can tie it to that. Can anyone
help me think of an easy way to put this formula
together. I would greatly appreciate the help.
 
Hi Cameron,

Which figure do you want to calculate, the monthly or
yearly? How is your data set up? Can you provide a small
example?

Biff
 
Hi Cameron,

Let me make sure I understand the commission calculation:

It's 50% for the first 92500 *PLUS* 5% for the balance
over 92500???

If that's the case try this formula, adjust the cell ref
as needed:

=IF(C10<=92500,C10*0.5,92500*0.5+(C10-92500)*0.05)

If this is not what you're looking for, you can send me
the file if possible so I can better see what it is you
need. You would need to change the address to biff_in_pitt.

Biff
 
Back
Top