Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 12th 05, 02:46 AM
Jas
 
Posts: n/a
Default HOW DO I REMOVE #VALUE FROM MY SPREAD SHEET

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

  #2   Report Post  
Old November 12th 05, 03:20 AM
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I remove the outline protection in Excel sheet? Rick Excel Discussion (Misc queries) 1 October 6th 05 07:43 PM
Can I Somehow load a Spread Sheet thru a Scanner murashid Charts and Charting in Excel 2 August 18th 05 01:12 PM
Can I Somehow load a Spread Sheet thru a Scanner murashid Excel Discussion (Misc queries) 4 August 18th 05 01:12 PM
Using a relative SHEET reference for source data in a chart James Charts and Charting in Excel 6 August 16th 05 05:07 PM
Excel window in spread sheet? WTG Excel Discussion (Misc queries) 3 April 14th 05 07:03 PM


All times are GMT +1. The time now is 02:12 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017