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.
Page 1 / 1
What 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 
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.
it work!!! thanks so much!!! I really really appreciate it !!!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.