How can I stop a calculation when a total reaches a maximum value?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to be able to stop a calculation when my total dollar value in a certain cell reaches $7,000.00. Right now, I have it set up to calculate 1.8% of a gross dollar amount. When the gross dollar amount reaches $7,000.00, I would like Excel to stop calculating the 1.8%. Is there a way to tell Excel to do this?
 
Hi!

It would be helpful to know how you have set it up so far and how yo
make it do its job.

Al
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Payroll - net to gross? 3
Sum is not correct after adding calculated fields 4
calculating a sum that contains a 0 or no data 6
Set total amount for an equation..... 4
Calculating When Somebody Reaches a Certain Age 4
Calculated Fields showing error results 1
Excel Stop Excel from displaying rounded values 4
how do i set up a profit margin formula 4

Back
Top