Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Help with finding the percentage difference of 2 number

Topic Labels: Formulas
408 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi would someone be able to help me create a formula to find the % difference of 2 numbers?

image

Thanks!

1 Reply 1

Hi Brittany. You’ll have to think about what your denominator should be. Here’s an option for % difference.

ABS(({Sold} - {Listed}) / {Listed})

Here’s an option for % of Listed that was Sold.

{Sold} / {Listed}

Format your formula field as a %. Cheers!