Variance Report - Need to reflect 0%

J

JDM

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

Adilson Soledade

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to create a variance percentage 1
If Function Greater than Less Than 2
Having a 'not applicable' with a 0 ranking on a rating question 0
Formatting question: how to format duration (time spent)? 0
The custom field could not be saved due to the following reason(s):This formula contains errors. Cor 1
help with formula 1
Extract name, address and ph# 8
Stop Light on Work Variance 3

Top