Get instant live expert help on I need help with sale margin formula

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

what formula i shouldbe using in order to work outon Mark-up on cost of goods sold and margin of profit on sale
Solved by V. W. in 28 mins
calculate (using profit calculator) minimum sale price needed to achieve set profit margin for various cost price increments
Solved by S. H. in 23 mins
Create a price table of minimum sale prices for an item based on hitting a predetermined profit margin for each price increment
Solved by D. D. in 17 mins
I need a formula to calculate a profit margin of 25%. I need to know what my minimum sale price can be to always maintain at least a 25% minimum profit margin. I have a fixed fee of $5 (column D). Another fixed fee of 15% of sale price (column C). Fixed cost of goods sold (column A). While my variables will change, what forumla can I use to always get a result of 25% without having to play with changing the sale price constantly. I need to do this across thousands of products.
Solved by D. H. in 11 mins
Currently I have a formula which add 20% margin (/.08) to the formula overall. I need it to add 20% margin OR £150., which ever is the greatest. Can you help please?
Solved by Z. S. in 14 mins