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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!