ExcelBanter - Variance Report - Need to reflect 0%

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - Variance Report - Need to reflect 0% (https://www.excelbanter.com/setting-up-configuration-excel/186792-variance-report-need-reflect-0%25.html)

JDM

Variance Report - Need to reflect 0%

Hello! I need my variance number to show 0% even when the formula's answer
is #DIV/0!

Adilson Soledade

Variance Report - Need to reflect 0%

If your data is the range A1:A100, you could use this:
=IF(ISERROR(VAR(A1:A100)),0,VAR(A1:A100))
To show the % sign just change the cell format.
--
Adilson Soledade

"JDM" wrote:

Hello! I need my variance number to show 0% even when the formula's answer
is #DIV/0!

All times are GMT +1. The time now is 03:03 PM.