View Single Post
  #3   Report Post  
 
Posts: n/a
Default

CyndiP wrote:
I am stumped on a formula... if ANY one can help me
- please post!!!


Keep in mind that there are many ways to do the same thing.

If X amount is between $.01 - $25 then take 8% of that
number = ?

If X amount is between $25.01 - $1000 then take 8% of the
$.01 - $25 then 5% of the remaining = ?

If X amount is over $1000.01 then take 8% of the $.01 - $25,
5% of the $25.01 - $1000 then 3% for the remaining = ?


(I think you mean "over $1000".)

=ROUND(8%*MIN(25,A1) + 5%*MAX(0,MIN(1000-25,A1-25)) +
3%*MAX(0,A1-1000),2)

Caveat: You might want ROUND(...,2) around each sub-expression
instead of the final sum. Also, "1000-25" can be written simply
750. I wrote it as such so that you can see the derivation.