percentage Formula

Mule

New Member
Joined
Feb 10, 2005
Messages
3
WOW, What a great site!!!

I am trying to create a excel sheet for my wife to keep her e-bay sales records. Our goal is to track profit ratios on certain items. can someone help me with a formula the help us with this.

One colum would be for the purchaes price of a item and another for the sales price, and a third colun for the profit ratio.

For instance: She buys an item at the store for $10 and sells it on e-bay for $20 = 100% profit.

Thanks in advance,

Mule
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

boxsterman

Active Member
Joined
Apr 16, 2002
Messages
279
Column A would be Cost
Column B would be Price
Column C would be profit margin - the formla would be =(b1-a1)/a1

you can then format the cells for percentages - otherwise it would just show a 1 and not 100%.
 

Mule

New Member
Joined
Feb 10, 2005
Messages
3
Thanks Box,

Seems to work, except I get a negative number in the profit margin column. No big deal, but can I fix that?

Mule
 

boxsterman

Active Member
Joined
Apr 16, 2002
Messages
279
I think you might have the cost and price columns mixed up.... if the price is greater than the cost.... the profit margin would be positive.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,232
Messages
5,594,962
Members
413,954
Latest member
mrsandy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top