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

P

PCC

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?
 
A

AlfD

Hi!

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

Al
 
Top