| Discussion: | All Topics |
| Topic: | How can I make a formula in Excel so I can figure out the profit MARGIN? |
| Post a new topic to the General Discussion in Probability & Statistics on Excel discussion |
| ||||||||
| Subject: | RE: How can I make a formula in Excel so I can figure out the profit MARGIN? |
| Author: | FByrne |
| Date: | Mar 30 2009 |
 |
|
> If I buy something at 11.70 and sell it for 16.02
How do I
> program EXCEL to automatically figure out the PROFIT MARGIN for me?
> I have a lot of product and I see EXCEL to do this for me on like
> 100 products...
Firstly, in a new cell, I would subtract using cell references the 11.70 from
the 16.02 and call this the Net Profit. Then in another new cell I would divide
the Net Profit figure (4.32 in this case) by the revenue figure (16.02 in this
case) again use cell references. I would format excel to show this figure as a
percentage and call it the Profit Margin.
| |||||||
| Post a new topic to the General Discussion in Probability & Statistics on Excel discussion | |||||||
| Visit related
discussions: Probability & Statistics Excel | |||||||