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
Sep 02, 2021 01:34 PM
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
Solved! Go to Solution.
Sep 03, 2021 06:27 AM
Just use the new formula. Notice that the new formula contains the previous formula embedded in it.
Sep 02, 2021 02:47 PM
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.
Sep 03, 2021 02:30 AM
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
Sep 03, 2021 06:15 AM
IF(
AND({Current Value} & "", {Original Value}),
({Current Value} - {Original Value}) / {Original Value}
)
Sep 03, 2021 06:20 AM
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!
Sep 03, 2021 06:27 AM
Just use the new formula. Notice that the new formula contains the previous formula embedded in it.
Sep 03, 2021 06:39 AM
Wow, I didn’t look close enough lol. Thanks, kuovonne :slightly_smiling_face: