View Single Post
  #2   Report Post  
Ron Coderre
 
Posts: n/a
Default

Try this:
The markup value:
Select C2
FormatCellsNumber
Category: Custom
Type: [<=1.5]0.00%;[1.5]$0.00;General
Click [OK]

Then the markup amount:
D2: =IF(C3<=1.5,B3*C3,C3)

The Total Price
E2: =+B3+D3

By doing the above, if a user enters a value less than or equal to 1.5 as a
markup...it is assumed to be a percent. Amounts above 1.5 are assumed to be
dollars.

Does that work for you?

Regards,
Ron