Calculating % with a minimum value
I'm looking for a formula that calculates the percentage of two columns, but shows a minimum percentage of 50% if the calculation is less than that.
Is this possible to do in one column, or do I need to have one column with the percentage, and the next with an IF function?
My knowledge of functions is limited so thanks in advance for helping with a potentially basic question!
Best Answer
-
Try this...
=IF([COVID Venue Capacity]@row / [Venue Capacity]@row < .5, .5, [COVID Venue Capacity]@row / [Venue Capacity]@row)
Answers
-
Hi @Natasha Fox
Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi @Natasha Fox
I hope you're well and safe!
Try something like this.
=IF(AVERAGEIF(ColumnOne:ColumnTwo; <>"") <= 0,5; 0,5; AVERAGEIF(ColumnOne:ColumnTwo; <>""))
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi @Bassam.M Khalil ,
Thanks for the reply.
It's really very simple but hopefully the visual helps. I am looking for the "Covid Venue Capacity %" column (the third one) to show what percentage the COVID venue capacity column is of the Venue capacity, but with a minimum of 50%.
So in the example illustrated I would want it to read 50% for the top row, and 60% for the second row and so on. In the example I have manually input the percentages.
-
-
Try this...
=IF([COVID Venue Capacity]@row / [Venue Capacity]@row < .5, .5, [COVID Venue Capacity]@row / [Venue Capacity]@row)
-
@Paul Newcome This worked- thanks so much!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!