Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Airtable Community
- Discussions
- Ask A Question
- Formulas
- How do I create this percentage formula?

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Topic Labels:
Formulas

Solved

Jump to Solution

0
2979
6

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Comment Post Options

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

1 Solution

Accepted Solutions

Solved
See Solution in Thread

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Sep 03, 2021 06:27 AM

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

6 Replies 6

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Sep 03, 2021 06:15 AM

```
IF(
AND({Current Value} & "", {Original Value}),
({Current Value} - {Original Value}) / {Original Value}
)
```

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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!

Solved
See Solution in Thread

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Sep 03, 2021 06:27 AM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Sep 03, 2021 06:39 AM

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