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
I need help translating this simple cvs formula to airtable
Best answer by ScottWorld
This is the formula I am using in Excel
And this is the formula I am trying on airtable 
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.
This topic has been closed for replies.
+35What is the formula you are using in Airtable? Please provide screenshots of your Airtable system as well.
What is the formula you are using in Airtable? Please provide screenshots of your Airtable system as well.
This is the formula I am using in Excel
And this is the formula I am trying on airtable 
+35This is the formula I am using in Excel
And this is the formula I am trying on airtable 
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.