Excel Monthly report

[lee1767]

Hi, all sifu.


I have a monthly report.

Now, I need to prepare the monthly as at March 2011.

For example :


This is a table with formula :


Jan Feb Mar Apr June Jul and so on....

Cost 1.00 2.00 3.00 #DIV/0! #DIV/0!


How to make the error disappear?

I do not want to show the error in my report.

If I delete it, then the formula will be deleted also.

So when I prepare the report for Apr, I need to copy back the formula.


Please help.


Thank you.

 

[Hui]

In the row where the error is, change it to have a formula like

=IFERROR(Old Formula, 0)

or

=IFERROR(Old Formula, "")

depends on your needs

 

[lee1767]

Thanks Hui for your help....