formula to return an empty cell

[tipperjoe]

Hi
I have a formula below that I want to return an empty cell instead of "" when formula is false. Is this possible ?

Appreciate any help
Joe

<TABLE style="WIDTH: 62pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=83><COLGROUP><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 3035" width=83><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 62pt; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl70 height=17 width=83><TABLE style="WIDTH: 228pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=304><COLGROUP><COL style="WIDTH: 228pt; mso-width-source: userset; mso-width-alt: 9728" width=304><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 228pt; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 height=17 width=304>=IF(F61<=B61,SUM(F62:F64)/F61,"")</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

 

[VoG]

A formula has to return something, even if it is "" (null string).

 

[Andrew Poulsom]

Sorry, what you want isn't possible. If a cell contains a formula it's not empty. Maybe we can help you if you tell us why it needs to be empty.

 

[Jonmo1]

Unfortunately no..

If the cell contains a formula, it therefore is not empty..
"" is the closest you can get.


Is your issue that goto-blanks doesn't consider them blank?

 

[tipperjoe]

thanks for your replies guys, some background, I have a spreadsheet with data for each week of the year. First week in column b, second week in column c and so on. I also have a graph that reads this data. My graph is reading all 52 weeks. Each week I have to copy above formula out one column because if i copied to all columns/weeks my graph reads the formula as zero even though I have specified "". I thought making the cells appear empty would solve my problem

 

[Andrew Poulsom]

Have you tried?

=IF(F61<=B61,SUM(F62:F64)/F61,NA())

 

[tipperjoe]

Hi Andrew
That worked !!. Even though the spreadsheet has #n/a in columns for future weeks, my graph ignores these values and doesn't treat them as zeros (ie the graph line stops at current week). Thanks so much for your help, much appreciated

Joe