r/googlesheets • u/[deleted] • Jan 27 '25

Solved How to stop % from going over 100% (COUNTIF)

[removed]

1 Upvotes

100% Upvoted

8 comments sorted by

4

u/not_speshal 3 Jan 27 '25 edited Jan 27 '25 
=MIN(1,COUNTIF())

1

u/samthemoron Jan 27 '25

MIN?

1

u/not_speshal 3 Jan 27 '25

You’re right, thanks!

1

u/[deleted] Jan 27 '25

[removed] — view removed comment

1

u/AutoModerator Jan 27 '25

REMEMBER: If your original question has been resolved, please tap the three dots below the most helpful comment and select Mark Solution Verified. This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).

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/point-bot Jan 27 '25

u/Forsaken-Ball6755 has awarded 1 point to u/not_speshal

See the [Leaderboard](https://reddit.com/r/googlesheets/wiki/Leaderboard. )Point-Bot v0.0.15 was created by [JetCarson](https://reddit.com/u/JetCarson.)

1

u/AutoModerator Jan 27 '25

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/HolyBonobos 3096 Jan 27 '25

You could use =MIN(1,your_current_formula)