Corel WordPerfect - Don't Let Text Cells Mess Up Your Average Calculations (Quattro Pro 9/10/11/12)


Quattro Pro's @AVG function is smart enough to ignore blank cells in a range when calculating an average. However, any text cells in the averaged range are considered zeros. When the @AVG function uses that zero value in the calculation, the result is inaccurate. To ignore text cells when averaging values, use the @PUREAVG function instead. It works like the @AVG function but skips any labels (text in cells) when performing the calculation.

Go back