Hi All,
second request this morning please.I have a price list and need to calculate the selling price making
35%profit
40%profit
45%profit
Anyone able to help me please.
Thanks in advance.
Hi All,
second request this morning please.I have a price list and need to calculate the selling price making
35%profit
40%profit
45%profit
Anyone able to help me please.
Thanks in advance.
Try
=ROUND(price*(1+35%),2)
etc.
Hi Allgermanparts
How about
=ROUND((Price*Profit%)/(1+Profit%),2)
=cost/(1-margin%)
Hi Guys,
thanks for these-I'll try when work gets a bit quieter![]()
This should give you the sales price
=ROUND(cost_price/(1-profit),2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks