View Single Post
  #3   Report Post  
sdmccabe
 
Posts: n/a
Default

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?