Less than or equal to

[Alan K.]

I have to calculate markups on a net amount of cost so that the first markup
will be 10% for the first $10,000. Than the next box will be a markup of 5%
for net amount between $10,000 and $90,000 and the third box will be 1%
markup for amounts over $90,000. So for example, if the total net cost in
box D5 is $120,000
D6 would equal $1,000 (that's 10% of the first $10,000)
D7 would equal $4000 (that's 5% of 90,000-10,000)
D8 would equal $ 300 That's 1% of $120,000-90,000

Keep in mind that many time mthe total net could be under $10,000 or
somewheres below 90K or 120K.

Thanks

 

[Rick Rothstein \(MVP - VB\)]

I think this does what you want...

D6: =0.1*MIN(D5,10000)
D7: =0.05*MAX(0,MIN(80000,D5-10000))
D8: =0.01*MAX(0,D5-90000)

Rick

 

[Bob Phillips]

D6:=MIN(10000,D5)*10%
D7: =MIN(80000,MAX(0,D5-10000))*5%
D8: =MAX(0,D5-90000)*1%

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)