ExcelBanter - Variance Report - Need to reflect 0%

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Variance Report - Need to reflect 0% (https://www.excelbanter.com/excel-discussion-misc-queries/186777-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!

Peo Sjoblom

Variance Report - Need to reflect 0%

=IF(A2=0,0,B2/A2)

adapt to fit

--

Regards,

Peo Sjoblom

"JDM" wrote in message
...
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 05:44 AM.