| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I make a column that calculates gross margin percentage
|
|
#2
|
|||
|
|||
|
Jimv,
In column A put your Net Operating Revenue (Gross Revenue less any Revenue Reductions). In column B put your Net Operating Income (Net Operating Revenue less Expense). In column C, subtract column B from A to Net Operating Income. In column D, divide Net Operating Income (column C) by Net Operating Revenue (column A) to get your Gross Margin Percentage. Regards, John Mansfield -----Original Message----- . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| how do I make the left margin of a header the same as the page ma. | Excel Discussion (Misc queries) | |||
| How do I indent a decimal aligned column from the margin? | Excel Discussion (Misc queries) | |||
| How can I sort an entire spreadsheet from a list | Excel Worksheet Functions | |||
| Copying the contents of a column into a chart | Excel Worksheet Functions | |||
Hybrid Mode
