I have a worksheet that identifies a unit description, a unit cost, a markup
percentage, a markup price and a total price from left to right across a
worksheet. The users input the unit description in cell A(x) using drop down
list thru data validation. The users input the unit cost in cell B(x). Then
the users enter a markup percentage in cell C(x). Cells D(x) and E(x) are
protected formulas that calculate the markup amount and the total price. I
need to give the users the choice in how they markup the unit cost either by
percentage or a flat dollar amount. Which ever the user chooses, I would
need the other to populate in it's cell and possibly also be protected,
therefore the user can only make one choice. After the choice, the totaling
column also needs to calculate the respective value. Any suggestions--Thanks