How to delete away the formula, when there is no value in it

[ru_1985]

HI ALL.

How can i delete away the formula, when the is no value in it?
Or is there anyway to delete away e ZERO in the graph... so tat the line graph will not shown ZERO and it will left a blank...

=IF(INDEX('AML101-ETCH'!B13:B47,MATCH('POLY ETCH CD DATA'!B17,'AML101-ETCH'!A13:A47,1))=0,"",INDEX('AML101-ETCH'!B13:B47,MATCH('POLY ETCH CD DATA'!B17,'AML101-ETCH'!A13:A47,1)))

Which mean, when the cell in blank. it will not be able to have any formula in it...

 

[acw]

Hi

Change the "" in the formula to na()

This will give the #N/A error, which is not graphed.

Tony

 

[ru_1985]

this is not i want... i wan to delete away the formula away. when there is a blank in it... tat mean no formula will be shown in the cell...

THAnks for ur code..

 

[Joe4]

Per forum rules, please stop re-posting the same questions, or variations thereof. Post back to the original thread:
http://www.mrexcel.com/board2/viewtopic.php?t=237530&highlight=