Finding the Percentage of A Number


#1

I am making a stock table to keep track of the stocks I have bought and sold. I ran into a formula problem I can’t solve. If I buy a stock at say $22.56 and I want to put a trailing stop on my stock of 20%, how should I do the formula to calculate that for me? In other words that stock went up to $56.40 and I want to sell that stock when it gets to 20% of that high of $56.40 which would be $45.12. In Excel the formula is High Price times 0.8, but with Airtable you use names of fields and I’m pretty new to Airtable, Help would be greatly appreciated. And thanks in advance

Pat


#2

In Excel you can put a formula in any cell, in Airtable you need a Formula field: