Hi, I have created a formula column that I want to divide the values in two other columns. But when I add the percentage option, the formula does not calculate the values correctly.
Could you possible share the formulas here with a screenshot?
the formula you are using to divide the values in two columns and calculate the percentage is probably incorrect. The correct formula should be:
If you are still having trouble getting the formula to work correctly.
Try using a different formula, such as the
AVERAGE() function, to calculate the percentage.