| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
| Need Formula or Function to calculate Margin (reverse of Percent a | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
| How do I make a column that calculates gross margin percentage | Excel Worksheet Functions | |||
Threaded Mode
