Hi - hope someone can help with this.
I'm creating an order form in Excel, and would like to have a discount
schedule built in - the higher the list price, the higher the discount. In my
order totals section at the bottom of the page, I have a cell for List Price,
a cell for Discount, and a cell for Net Price.
Further over to the right I have the discount ranges entered into separate
cells (these will be hidden when it is completed so the customer can't
see/change it). Column AA is the low dollar value for the range, column AB is
the high dollar value or the range, and AC is the applicable discount for
Column AA Column AB Column AC
$0 $25,000 0%
$25,001 $60,000 5%
$60,001 $110,000 10%
$110,001 $275,000 15%
$275,001 $750,000 20%
$750,001 and up 25%
So basically, if the list price is between $0 and $25,000 then the discount
is 0%. If the List price is between $25,001 and $60,000 then the discount is
5%, etc... What I'm trying to do is have the Discount cell in my totals
section automatically insert the correct discount % depending on what the
value in the List Price cell is.
My knowledge of nesting IF and OR statements is pretty basic (which is what I
am assuming is needed). I've tried a few things but couldn't get it working.
I've also done some searching around here but couldn't see anything that
covers this situation.
Any help would be appreciated.
Message posted via http://www.officekb.com
pajones via OfficeKB.com