UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> #VALUE!    
 
   
JIMBO
post Jul 9 2002, 10:19 AM
Post#1



Posts: 103
Joined: 27-June 00
From: Roanoke, Virginia


I am paste linking from other sheets into one sheet. The problem is some of the fields are blank or null. The result is #value!. Is there a function or a way excel will add fields to avoid this message? Any comments will be appreciated.
Thanks
Jim
Go to the top of the page
 
gcarlsonjr
post Jul 9 2002, 01:46 PM
Post#2



Posts: 48
Joined: 1-November 00
From: Englewood, Florida USA


You can check out the IS Function within the EXCEL Help. You check out ERROR.TYPE, too.
Go to the top of the page
 
Scomac
post Jul 10 2002, 04:01 AM
Post#3



Posts: 969
Joined: 15-February 01
From: Scotland


Paste Linking? wots that? Do you Copy then paste or are you setting a reference to a cell on another sheet.
If your setting a cell reference us an if statement like so
=IF(Sheet2!A1="","No Value",Sheet2!A1)
if your copy pasting it should bring back the blank unless you have formulas in the copyied range.
regards
Scottie
Go to the top of the page
 
JIMBO
post Jul 10 2002, 07:15 AM
Post#4



Posts: 103
Joined: 27-June 00
From: Roanoke, Virginia


I was adding fields from other sheets. It turned out that they were default to text format. I used an If statement and ISTEXT function. That took care of it. Thanks for your help.
im
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    9th December 2019 - 10:12 AM