# Thread: How to calculate a margin

1. Registered User
Join Date
Feb 2004
Posts
99

## Unanswered: How to calculate a margin

Hopefully a no brainer but as ever I struggle with the techie terms and can't lookup help!!!

In layman terms...

I have a table with two fields..

1) Cost (cost of purchase) = \$12
2) Price (price sold) = \$23

I want to calculate the margin at which it is sold e.g. price - cost x 100 = %age margin

How the **** do I get this to work, sounds easy to do as it is nothing like rocket science but asa ever it evades me! If you can point me in the right direction with some instructions or with the right term to dig around the 'net for help I'd be very grateful.

Thanks

2. Purveyor of Discontent
Join Date
Mar 2003
Location
The Bottom of The Barrel
Posts
6,102
How are your tables set up? You can write formulas in queries similar to using a spreadsheet, but where the data comes from is going to depend on how you setup your tables.

3. Grand Poobah
Join Date
Sep 2003
Location
MI
Posts
3,713
The only way that I've ever done margins is by taking the cost and multiplying by the margin Ex:

Cost X * 1.085 = Price [8.5% markup]

So: Do the math ... Margin = Price / (Cost * 100)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•