
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 25, 2020 12:27 PM
I need to obtain a simple margin profit.
the formula i use in excel is this one: =(retail price / wholesale price) - 1
Everytime I try it doesn’t give me the right answer.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 25, 2020 01:02 PM
Your Airtable screenshot didn’t come through properly.
My guess is that your formula would look something like this:
( {Retail Price Field} / {Wholesale Price Field} ) - 1
Keep the {brackets}, but replace “Retail Price Field” and “Wholesale Price Field” with the actual names of your fields in Airtable.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 25, 2020 12:30 PM
What is the formula you are using in Airtable? Please provide screenshots of your Airtable system as well.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 25, 2020 12:39 PM
This is the formula I am using in Excel
And this is the formula I am trying on airtable 

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 25, 2020 01:02 PM
Your Airtable screenshot didn’t come through properly.
My guess is that your formula would look something like this:
( {Retail Price Field} / {Wholesale Price Field} ) - 1
Keep the {brackets}, but replace “Retail Price Field” and “Wholesale Price Field” with the actual names of your fields in Airtable.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 25, 2020 01:23 PM
it work!!! thanks so much!!! I really really appreciate it !!!
