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.
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.
Jun 25, 2020 12:30 PM
What is the formula you are using in Airtable? Please provide screenshots of your Airtable system as well.
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 ![Screen Shot 2020-06-25 at 1.39.16 PM|700x372](upload: //5Hpx4lqxHwzscrs4W7PtBFbaFf7.png)
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.
Jun 25, 2020 01:23 PM
it work!!! thanks so much!!! I really really appreciate it !!!