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 Cameron
Can anyone answer this: When i paste in info from a web site, one of the columns contains numbers, yet when I try to refer to those numbers in formulas in...
October 17th, 2003 02:54 AM
by Dave Peterson Go to last post
2 147
#value! by wal50
I am using the following which puts a 0 in the field when the lookup finds...
June 2nd, 2006 02:26 PM
by wal50 Go to last post
7 60
#VALUE! by Curtis
I am trying to add two cells and ach cell contains a formaula. I keep getting the error #VALUE! when one of cells does not produce a value Is there any way...
November 21st, 2006 06:19 PM
by Curtis Go to last post
4 66
#VALUE! - how to get rid of it? by Claudia
If I do have a main formula which looks like this: =(CL5-EH5-CL5*0.85*$EY$5-CL5*$EX$5-CL5*0.85*$EU$5)*BZ5 and the variables are based on the formula for...
May 21st, 2007 03:22 PM
by Claudia Go to last post
2 70
#value! Error by sony654
The below function returns a #value! error. I would like the below function to return "-" only if every cell in the range is empty. Help is appreciated...
July 5th, 2008 05:05 AM
by T. Valko Go to last post
3 110
#VALUE! error by dim
Hi...again...Im sure this is really simple.... I've put in a formula: =IF(I9="y","mm Used This Job"),IF(K9="y","cm Used This Job") It works fine until the...
October 10th, 2007 11:07 PM
by dim Go to last post
3 101
#Value! error by HalB
How does one "overcome" the #Value! error when used in a function? Example: A1= "4 DR. SEDAN" I want to FIND "DR." The formula I use is =FIND("DR.",A1,1)...
(Multi-page thread 1 2)
March 28th, 2007 07:02 AM
by Anne Troy[_2_] Go to last post
12 108
#VALUE! error by Anthony
Hi, I have the #VALUE! error which I can't seem to work out why. the formula in the cell is =SUMPRODUCT(--(DateofLog=($U16)),--(crew="Y")) and I have...
December 26th, 2005 12:37 PM
by Bob Phillips Go to last post
2 101
#Value! Error as result of Calculation by Jay
This Error is generated by a formula like so: =(J14-K14)/J14. Is the there a simple method of resolving this error to be either having an empty "" string or 0...
June 16th, 2004 09:35 PM
by Harlan Grove Go to last post
3 110
#value! error in sum function by Art
I need to sum a range of cells. Some of the cells may contain text. If so, the function returns #value!. In Lotus 1-2-3, text is treated as 0 for function...
October 23rd, 2009 04:54 PM
by T. Valko Go to last post
8 125
#VALUE! error message help needed please by Bob Newman
I have a very simple checking account SS. All has been working fine. Now all of a sudden about halfway down the balance column I get a #VALUE! error...
November 25th, 2007 05:56 PM
by Bob Newman Go to last post
3 95
#VALUE! error message in simple sum function by Sandog
I am getting a weird error message doing the simplest sum function. I have a column with 10 filled cells, I7-I16. In a cell below that I enter...
July 29th, 2008 06:59 PM
by Sandog Go to last post
4 119
#Value! Error when Concatenating by LymaBeane
I am trying to concatenate two fields together. They are both numerical fields. I have never had a problem but for some reason some work but most give me the...
March 20th, 2006 10:03 PM
by Kevin Vaughn Go to last post
5 121
#Value! error when evaluating data in a cell range by Simon Woods[_3_]
I have a worksheet where I need to calculate the sum of a range of cells containing a text string and a number, for example: If I had the cell values: 8ABC,...
January 13th, 2009 11:38 PM
by Mike H Go to last post
7 72
#VALUE! error when trying to add cells (VLOOKUP) by sandy
I am trying to add cells that have been filled with the VLOOKUP function. =SUM(F6+I6+L6+O6+R6+T6) Those cells have a value from a VLOOKUP...
February 27th, 2009 12:47 AM
by Ashish Mathur[_2_] Go to last post
8 143
#value! for calculating date by NANGO
I have a quote template with calculates a "quote valid until" date based on adding 30 days to the date of the quote. The issue I have is that if the quote...
April 27th, 2007 12:49 AM
by Pete_UK Go to last post
2 52
#VALUE! from SUMPRODUCT by gte
I have a problem with SUMPRODUCT. If I use this function: =SUMPRODUCT($I$58:$I$108;OFFSET($H$58;58-ROW();0;51;1)) I get #VALUE! error. But if I...
January 15th, 2008 07:16 PM
by T. Valko Go to last post
8 75
#VALUE! in cell by datub
My formula is =SUM(B8:C8)*G8 where either B8 or C8 will always =0. How do I not get this value" #VALUE!" when the cells are not in use?
December 19th, 2009 03:28 AM
by David Biddulph Go to last post
5 108
#value! in linked document by TamIam
Hi there, is there any way to automatically update linked documents without opening the source document? When I leave them closed, my main worksheet shows...
May 15th, 2010 01:35 AM
by Ashish Mathur[_2_] Go to last post
2 155
#VALUE! in Time Calculation by michelle
I have a spread sheet that shows when someone checked in/out and the time that they were removed from the log. I want to calculate the time between the...
August 10th, 2006 08:54 PM
by Bob Phillips Go to last post
2 148
Post New Thread


Display Options
Showing threads 281 to 300 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 09:42 AM.


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