I am working on a pricing model and I am having a challenge programming cell
$D$24. Currently it reads as follows however I now need to add another
element to it.

IF($E$24=0,("
"),IF(AND($E$240,$D$13=1,$D$13<=25),("$500"),IF( AND($E$240,$D$13=26,$D$13<=50),("$750"),IF(AND($ E$240,$D$13=51,$D$13<=150),("$1,500"),IF(AND($E$ 240,$D$13=151,$D$13<=250),("$2,000"),IF(AND($E$2 40,$D$13=251),("$5,000"),IF(AND($E$24=1,$D$13=0) ,("# of Vehicles MUST be 0")," ")))))))

Cell $D$24 now varies based on cell $D$15. Cell $D$15 is a data validation
drop down allowing the cell to either be blank or say "Affiliate". When
"Affiliate" is selected, I need the pricing in cell $D$24 to reduce by 50%.
For example, instead of $500, $750, $1,500, $2,000 and $5,000, I need it to
be $250, $375, $750, $1,000 and $2,500. This occurs when $E$24=0, when
$D$13 mirrors the information above and when $D$15="Affiliate"
--
Cathy