Thank you!!!! You just saved me hours trying to figure this out!!!!



"Harlan Grove" wrote:

Wutnik wrote...
....
If the subtotal (ie E74) is 100,000 or less = 6% of E74. If the subtotal
is over 100,000, 6% on the first 100,000, 4% on the next 400,000 and 2% above
500,000.
....

=6%*MIN(E74,100000)+4%*MAX(MIN(E74-100000,400000),0)+2%*MAX(E74-500000,0)