Perfect Bill K - thanks!
"Bill Kuunders" wrote:
A1 is cost price
B1 is percentage markup entered as a % i.e. 40% or as a general number
0.4
enter in C1
=A1/(1-B1)
--
Greetings from New Zealand
Bill K
"sdmccabe" wrote in message
...
I need a formula to produce a selling price when cost is known and desired
gross margin (on sales) is an input variable.
For example, cost equal $60, desired gross margin (percent) equals 40; the
result would be $100
Can you help a rookie?
|