Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
JDM JDM is offline
external usenet poster
 
Posts: 7
Default Variance Report - Need to reflect 0%

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


  #2   Report Post  
Posted to microsoft.public.excel.setup
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!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Variance Report - Need to reflect 0% JDM Excel Discussion (Misc queries) 1 May 9th 08 12:22 AM
how do I reflect a (-) outcome as 0 mike Excel Worksheet Functions 3 April 2nd 08 12:27 AM
Automate Excel report to place certain data into existing report? Craig Harrison Excel Worksheet Functions 3 July 25th 06 01:54 PM
Pivot Tables - Variance and Variance % PJS Excel Discussion (Misc queries) 2 January 18th 06 04:12 AM
Pivot Tables - Variance and % Variance fields CraigS Excel Discussion (Misc queries) 5 January 6th 05 01:22 AM


All times are GMT +1. The time now is 09:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"