# How do I create this percentage formula?

Topic Labels: Formulas
Solved
1823 6
cancel
Showing results for
Did you mean:
6 - Interface Innovator

Hey all, I’d love a hand with a formula if anyone knows this?

I’d like to find what % a number is of another number, if that makes sense…

So for example…

If I have \$500 in an investment account, and that investment is currently sitting at \$750, what’s the formula to show the % increase (which equals to 50%)?

The formula would of course show the opposite of -50% if the investment fell to \$250.

Any help is greatly appreciated. Thanks! Christopher

1 Solution

Accepted Solutions
18 - Pluto

Just use the new formula. Notice that the new formula contains the previous formula embedded in it.

6 Replies 6
18 - Pluto

It sounds like you want to know the percent change, which is slightly different from what percent is x of y.

This will give percent change:

``````({Current Value} - {Original Value}) / {Original Value}
``````

Be sure to adjust the format settings of the formula field to display as a percent.

6 - Interface Innovator

Thank you so much, @kuovonne - that’s exactly what I need.

Question - for the past cells that don’t have a value, how do I remove the NaN? Is there something I can add to the formula to do that?

Thanks!
Christopher

18 - Pluto
``````IF(
AND({Current Value} & "", {Original Value}),
({Current Value} - {Original Value}) / {Original Value}
)
``````
6 - Interface Innovator

Thanks kuovonne. How do I actually “add” this to the existing formula?

({Current Value} - {Original Value}) / {Original Value}

Then…

IF(
AND({Current Value} & “”, {Original Value}),
({Current Value} - {Original Value}) / {Original Value}
)

I tried to do this but get an error so I’m obviously doing it incorrectly. Thanks!

18 - Pluto

Just use the new formula. Notice that the new formula contains the previous formula embedded in it.

6 - Interface Innovator

Wow, I didn’t look close enough lol. Thanks, kuovonne :slightly_smiling_face: