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!