percentage Formula

[Mule]

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

 

[boxsterman]

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]

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]

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.

 

[Mule]

you are correct

Thanks Again ray: