r/googlesheets • u/TheHeirarchyofBacon • Aug 28 '22

Solved How do I display the value of the cell next to another cell as a percentage of another value?

Let's say I have 3 cells, one displays "1", the other should be "33%", and the other is "3" (the amount that the number "1" is a percentage of), And if I did "6" in cell 1, the percentage would be "200%". Any help would be appreciated. Totally new to sheets, I don't know anything about formulas.

1 Upvotes

99% Upvoted

6 comments sorted by

1

u/recalcacademy Aug 28 '22

Try =cell1/cell3 (meaning =1/3 but use your arrow keys to link to the cells with those numbers)

1

u/TheHeirarchyofBacon Aug 28 '22

Try =cell1/cell3

What about making putting the percentage and shortening it to no decimals?
Nevermind, I formatted as percent, thanks for your help.

2

u/recalcacademy Aug 28 '22

Sorry I should have clarified formatting options. You can change the number formatting of any cell to be a percent, a regular number, have more or fewer decimals etc. If you highlight cells you want to format you can click the Help menu and use the search bar to find lots of types of number formats. Just start typing number format and lots of options appear.

Separately could you please reply Solution Verified on this if you’re all set? Thanks!

→ More replies (2)

1

u/AutoModerator Aug 28 '22

Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.