MrExcel Publishing
Your One Stop for Excel Tips & Solutions

error checking

Posted by helen mullinder on July 19, 2001 5:40 AM

I am currently working on a hnc excel assignment. How can I prevent cells which contain a formula from displaying an error message when the cells on which the calculation is based is empty. I want the rest of the work sheet to appear blank until the first column of cells have been filled

Posted by Scott S. on July 19, 2001 6:23 AM

You could try a simple If formula like:

=If(A1="","",[Your formula])

Posted by Mark W. on July 19, 2001 6:59 AM

=IF(ISBLANK(A1),"",[Your formula])