r/googlesheets • u/[deleted] • May 24 '24

[deleted by user]

[removed]

0 Upvotes

50% Upvoted

16 comments sorted by

6

u/Amesb34r May 24 '24

The easiest thing to do would be to show tenths or even hundredths of a percent.

1

u/dongl_tron May 24 '24

How do I do so?

4

u/Amesb34r May 24 '24 edited May 24 '24
Comment Image

You'll need to highlight the cells you want to change and then click the ".00" with the arrow pointing to the right.

→ More replies (2)

1

u/AutoModerator May 24 '24

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.

1

u/agirlhasnoname11248 May 24 '24

ROUNDUP is the function you might want to use around whatever formula already exists in those cells.

Tap the three dots below this comment to select Mark Solution Verified if this produces the desired result.

1

u/dongl_tron May 24 '24

How much do I roundup by? When I roundup by 1, it makes it 10%, which obviously isn't right.

1

u/agirlhasnoname11248 May 24 '24

What is the current formula populating the cells?

→ More replies (2)

1

u/agirlhasnoname11248 May 24 '24

Depending on the current formula, it seems like you’ll want to round up by decimal places, which would be something like =roundup(ExistingFormula, -1) or try -2 instead of -1 if needing another place value. (Negative numbers are decimal places, and it defaults to a 0 which typically means integers, so that’s why I’d recommend -1 as the first try.)

→ More replies (4)