I am designing a quote sheet where different markups will be placed
depending on different value.

As an example:

If a product is between 0 and 19.99 I want to mark it up 100%
If a product is between 20.00 and 49.99 I want to mark it up 60%
If a product is between 50.00 and 99.99 I want to mark it up 40%
If a product is over 100 I want to mark it up 35%

My actual price box will be lets say A1
My between price boxes will be B1,B2… B3,B4…B5,B6…B7
My Markups will be in C1,C2,C3,and C4.

And my result will be in D1.

Ok this is all hypothetical but you get the jest.

Can I write a singe code in box D1 to do the calculations or do I need
to break the code up with 4 different expressions?

Can someone just get me started with the code like =IF(A1B1 but <B2
use C1) ….

I can do all the basic stuff I just don’t know where to start with this
one.


Thanks

Todd


--
Xenos
------------------------------------------------------------------------
Xenos's Profile: http://www.excelforum.com/member.php...o&userid=26526
View this thread: http://www.excelforum.com/showthread...hreadid=397941