Hi Moe

Not exactly clear what you are after here.
If you multiply 17.99 * 20% you get 3.60
If you want to increase 17.99 by 20% then the formula is =17.99 *(1+20%)
= 21.59
If you want to decrease 17.99 by 20% then the formula is = 17.99
*(1-20%) = 14.39

If you are saying the Retail price is higher than List price by 20% and
the Retail price is 17.99
then to get the List price it is = 17.99/(1+20%) = 14.99

Can you explain more clearly what you are after, as the values you show
don't seem to match up.
--
Regards

Roger Govier


"Moe" wrote in message
...
How do I get to this function for excel to give me C1
List Price Retail price = $17.99 * 20% = new list price
$12.99 $29.99 = $20.00
A1 B1 C1