View Single Post
  #2   Report Post  
Ron Coderre
 
Posts: n/a
Default HOW DO I REMOVE #VALUE FROM MY SPREAD SHEET

You basically have 2 options here.

Prevent errors from printing
---------------------------------
If you're OK with seeing the errors on the worksheet, but DON'T want to see
them on the printed copies:
FilePage SetupSheet Tab
-Set Cell Errors to: (select one of the options)

Prevent errors from displaying or printing
-------------------------------------------------
If you don't want to see them on the worksheet or on the printed page, then
you have to build the solution into your formulas:
Example:
A1: 0
A2: 3
A3: =A2/A1 <-Returns #DIV/0!

Change A3 to: =IF(ISERROR(A2/A1),"",A2/A1)

That formula pre-tests the calculation to see if it returns an error.
If Yes, then it displays an empty string, otherwise it displays the formula
results.

Does that help?

€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron


"Jas" wrote:

After entering a formular into a cell. The formula works but the cell shows
"#VALUE! and if the cell is not used it prints value on the page.
How do I remove #VALUE
Please