View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Adilson Soledade Adilson Soledade is offline
external usenet poster
 
Posts: 19
Default 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!