| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Margin Formula
I have Cost (column A) and Selling Price (column B). I need a formula to
determine margin. Can anyone help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Margin Formula
Well. isn't it just the difference between what you sell it for and
what it cost you? Try this in C2: = B2 - A2 Copy this down as far as you need to. Hope this helps. Pete On May 1, 12:38*am, Lgirl wrote: I have Cost (column A) and Selling Price (column B). I need a formula to determine margin. Can anyone help? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Margin Formula
You probably want % margin, which is:
=(b1-a1)/b1 Regards, Fred. "Lgirl" wrote in message ... I have Cost (column A) and Selling Price (column B). I need a formula to determine margin. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for margin | Excel Discussion (Misc queries) | |||
| Formatting Footers from Margin to Margin | Excel Discussion (Misc queries) | |||
| margin of error formula | Excel Worksheet Functions | |||
| gross profit margin formula | Excel Discussion (Misc queries) | |||
| Margin/markup formula for Excel | New Users to Excel | |||
Linear Mode
