I need help translating this simple cvs formula to airtable

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.

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
Screen Shot 2020-06-25 at 1.34.46 PM

And this is the formula I am trying on airtable ![Screen Shot 2020-06-25 at 1.39.16 PM|700x372](upload: //5Hpx4lqxHwzscrs4W7PtBFbaFf7.png)

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 !!!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.