A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
#Value by Steved
Hello from Steved Below gives me...
July 26th, 2004 03:05 AM
by Steved Go to last post
2 92
#VALUE ! errorr for links to other workbook by Janez Banez
In one cell of my first workbook I have a link to the cells of the other workbook. If the second workbook is open, then the link formula...
January 15th, 2005 12:42 PM
by Arvi Laanemets Go to last post
1 351
#VALUE & #DIV0 by tonyalt3
I have entered several functions in my spreadsheet, however the cells they are dependant on do not currently have data entered in them. Is there a way to...
January 9th, 2008 02:46 PM
by tonyalt3 Go to last post
2 66
#VALUE about function Find by hui
I set A1="1978-9-22", B1="find("-",A1)" and return, but B1 shows #VALUE!, why? How can I resolve it? thanks in advance. A B ...
(Multi-page thread 1 2)
September 12th, 2006 04:01 PM
by hui Go to last post
14 195
#VALUE appears in Excel file with links using "No Update" by jjones
The links seem to be deteriorating in monthly reports sent to about 60 recipients. Using Excel 2000 files that contain links to a single source of data...
September 23rd, 2004 04:37 PM
by HJ Go to last post
3 549
#Value Being Returned for Blank or Non Zero Value by Jack
I am referring to a cell in my spreadsheet that currently has no value associated to it. I have a formula in the cell that refers back to another cell. For...
November 12th, 2007 06:09 PM
by RagDyeR Go to last post
9 62
#VALUE error by an
Hi! I have a time table with: A B 1 11:55:00 AM 2:20:00 PM If aplied the formulae =(B1-A1) return #VALUE error,...
November 23rd, 2007 02:09 AM
by an Go to last post
8 63
#VALUE error by BadBoy
This formula returns a #VALUE! error when empty. Can this be fixed? Thank you in advance. =IF(SUM(F17+H17)0,SUM(F17+H17),"")
September 18th, 2009 05:55 PM
by BadBoy Go to last post
3 108
#Value Error by Curtis
Why am I getting this error when I am trying to find the difference between 2 numbers say a6-a140 Each cell has a formula to pull data however in some cases...
October 5th, 2009 12:29 AM
by JoeU2004 Go to last post
3 163
#Value Error by caldog
Since you folks were so helpful last time I have another question for you. Say I have two cells A1 and B1 that has the cell formatted as (hh.mm.ss). Now...
November 8th, 2006 04:55 AM
by JMB Go to last post
1 81
#VALUE error on SUMIF formula linked to multiple worksheets by bknutzy
I am receiving a #VALUE error on a SUMIF formula that I have linked to an external spreadsheet. If I only have the spreadsheet with the SUMIF formula open,...
September 23rd, 2008 10:06 PM
by Dave Peterson Go to last post
1 136
#Value error when linking workbooks by FOLALD
Hello All, Hope you can assist. Excel 2003, SP1 XP Home ---I am using '=Countif' to extract only 1 criteria from another
September 13th, 2005 02:17 AM
by Dave Peterson Go to last post
1 129
#value error when opening spreadsheet by [email protected]
Help!! I have a spreadsheet which is linked to about 30 other spreadsheets. Most of the functions are just 'sum's and 'sumif''s. When I have all spreadsheets...
November 8th, 2006 04:22 PM
by [email protected] Go to last post
5 70
#VALUE error when referencing spreadsheet on sharepoint library by Lois Johns
I have two spreadsheets, one references a cell range in the other, both are in the same Sharepoint Document Library. When I choose to "Update", I get a #VALUE...
May 19th, 2005 05:38 PM
by Lois Johns Go to last post
2 110
#VALUE error when summing rows containing blank cells by John Iverson
I'm pretty new to Excel, but I thought (and it's beeen my experience) that it ignored blank cells when doing a simple SUM. I inherited a spreadsheet that sums...
November 19th, 2003 01:46 PM
by John Iverson Go to last post
2 405
#VALUE error with valid formula by jnewby72
When I open a workbook, one formula may or may not show the #VALUE error. After pressing F2 and Enter, the formula is calculated properly. I have tried using...
November 8th, 2006 04:32 PM
by jnewby72 Go to last post
2 59
#VALUE error-- some cells? by roborat
I am doing a VLOOKUP moving out comments from a Pivot Table to separate column. I have 115 rows, 100 of which work perfectly... but 15 of them give me the...
April 9th, 2010 07:47 PM
by Luke M[_4_] Go to last post
3 98
#VALUE Help by MrSales
I have a formula created and as a result of the functions it must go through it may return #VALUE. How can I get it to show nothing instead of...
March 30th, 2006 09:51 PM
by kassie Go to last post
2 63
#VALUE in cell by John
With the follwing formula in a cell, I get the #VALUE no matter what H39 value...
April 23rd, 2004 07:45 AM
by Leo Heuser Go to last post
3 91
#VALUE in Date calc by Martha
Afternoon: I am doing a simple calc (Date cell-30days) but the Date column is only partially completed and will be dynamic. How to get rid of the #VALUE...
March 5th, 2007 09:51 PM
by Pete_UK Go to last post
1 74
Post New Thread


Display Options
Showing threads 241 to 260 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.