gross profit margin formula

J

julmcgrath

I'm trying to figure out the formula for a gross profit margin percentage as
follows:

In Col A2, I will have a cost (i.e. $15.00)
In Col B2, I would like the result to be the total markup of $15.00 based on
a 40% gross profit margin, and then I need the resulting number to be rounded
up or down to the nearest $0.05, ending in a "5."

The resulting number should be $24.95, but I can't get it to come out that
way.
Any suggestions would be appreciated!
 
D

dlw

Getting the 40% markup is easy, right? The rounding is the tricky pary. Use
this formula:

=A1+0.05-((A1*10) - INT(A1*10))/10

A1 is the cell with the number you want to round.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i set up a profit margin formula 2
excel formula for markup and profit margin 3
Help with formulae 3
complicated excel formula may need an algebra wiz 1
future value and gross profit. 3
formula calculation 2
GP Formula Needed 5
spreadsheet with negitive numbers 1

Top