I need help translating this simple cvs formula to airtable

[Andrea_Padilla]

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.

[ScottWorld]

What is the formula you are using in Airtable? Please provide screenshots of your Airtable system as well.

[Andrea_Padilla]

This is the formula I am using in Excel

And this is the formula I am trying on airtable 

[ScottWorld · Accepted solution]

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.

[Andrea_Padilla]

it work!!! thanks so much!!! I really really appreciate it !!!