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 |