Re: Average Function (include Blank Cells and Zeros)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Steve, just us the IS function.

If you want to your final work*** to mirror exactly your input
worksheet, use =IF(ISBLANK(inputworksheetA1," ",inputworksheetA1).

Final work*** will no longer reflect zeros whenever your input
work*** is blank.


DangerMouse wrote:
I dont wish to hi-jack this thread, but might I ask how you accomplished
the displaying of blank cells as blanks in a linked workbook?

thanks

steve


--
DangerMouse
------------------------------------------------------------------------
DangerMouse's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27755
View this thread: http://www.excelforum.com/showthread.php?threadid=552656

.

Quantcast