Help

Percentage Difference between two numbers

Topic Labels: Formulas
Solved
Jump to Solution
1984 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Diane_Martinez
5 - Automation Enthusiast
5 - Automation Enthusiast

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
ScottWorld
18 - Pluto
18 - Pluto

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
ScottWorld
18 - Pluto
18 - Pluto

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.

Diane_Martinez
5 - Automation Enthusiast
5 - Automation Enthusiast

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