Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Percentage Difference between two numbers

Topic Labels: Formulas
Solved
Jump to Solution
739 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m trying to figure out the difference (in percentage) between two numbers.
Screen Shot 2022-02-04 at 7.48.37 PM
I’d like to set up a formula that gives the percentage (positive or negative) difference between two numbers.
So in the screenshot above
Row 1: Percentage decrease from 100 to 50
Row 2: Percentage increase from 25 to 50
Row 3: No change between 50 to 50

My formula so far: -(({Starting #} - {End #})/{Starting #})

1 Solution

Accepted Solutions

Welcome to the community, @Diane_Martinez!

It seems like your formula should work. If not, you could remove that leading minus sign and subtract the starting # from the end # (instead of the end # from the starting #).

Then, on the formatting tab for your formula, choose “percentage” to display the number as a percentage.

See Solution in Thread

2 Replies 2

Welcome to the community, @Diane_Martinez!

It seems like your formula should work. If not, you could remove that leading minus sign and subtract the starting # from the end # (instead of the end # from the starting #).

Then, on the formatting tab for your formula, choose “percentage” to display the number as a percentage.

That’s why it didn’t seem right. Thank you @ScottWorld!!