Help

Re: I need help translating this simple cvs formula to airtable

Solved
Jump to Solution
936 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Andrea_Padilla
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

1 Solution

Accepted Solutions

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.

See Solution in Thread

4 Replies 4

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.

Andrea_Padilla
5 - Automation Enthusiast
5 - Automation Enthusiast

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