View Single Post
  #1   Report Post  
julmcgrath
 
Posts: n/a
Default gross profit margin formula

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!