It would be helpful if you provide what the correct answer would be - however
you may want to try this
=((V10-U10)/X10)/V10) (if x10 = 2 in your example the amount you should get
would be 6.31%

Not sure how to address the percentage problem, need more clarification.

--
Wag more, bark less


"Wanna Learn" wrote:

Hello in Excel 2003 my formula is =(V10-U10/X10)/V10) this means
current list price - fixed price /by units sold / by current list price.
example current list price is $257,506.00 fixed price is $225,000.00 units
sold is 1 so the discount is 12.62% my problem is if there is more than 1
unit sold I get the wrong answer also when the fixed price is not a dollar
amount but a percent example 10% then my answer is also wrong. How do I
correct his thanks a million.