Nuke Modified | AntiVirus Remover

In excel 2000, how can I hide the error message #NUM! , while keeping the existing formula?

I am trying to create a work schedule that will automatically show months utilizing work when the start date is input. I have a fairly complex formula using if, and statements and referencing my input sheet. It all works fine, but when the cells aren’t being referenced they constantly have a #NUM! in the cell which can be very annoying visually. I only want the formulas to show data, when they are being referenced to the months utilizing work. ALL IN ALL, I need a way to hide the #NUM! message without affecting the original formula. I also have MS Excel 2000….Any ideas?

You can use an “if” statement.

=if(iserror(X:X),”",formula here)

Excel for Auditors $18.77 Providing the tools and techniques necessary for finding errors and fraud in audits, this guide for auditors looking to better validate their Microsoft Excel spreadsheets provides techniques for performing a risk assessment and gathering spreadsheet and other data from company systems. Performing audit data analysis using data and analytical management functions and pinpointing the common errors in spreadsheets with focused Excel tests is discussed, as are the best practices for error and fraud prevention when developing spreadsheets. This reference is fully updated to reflect Excel 12.

Vida Num So Dia $34.99 Vida Num So Dia

Message $14.99 Message

Roman Num – Size 10 $7.99 BodyCandy Roman Num – Size 10

Roman Num – Size 9 $7.99 BodyCandy Roman Num – Size 9

Roman Num – Size 11 $7.99 BodyCandy Roman Num – Size 11