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
#NAME? error associated with UDF by Bob
I have a shared workbook containing numerous formulas including UDFs. Sometimes, but not always, when I open the shared workbook, those cells containing a...
January 23rd, 2007 06:21 PM
by Bob Go to last post
0 83
#NAME? error for no apparent reason... by Monomeeth
Hello I'm getting the #NAME? error and I'm at a loss. I have the following formula in cell D4: =EOMONTH(D1,0) Now, the value of D1 is limited by a droplist...
September 15th, 2008 08:22 AM
by David Biddulph Go to last post
4 144
#Name? Error in User Defined VB Function by idgity
Hi, I'm new to making VB functions for Excel, but I managed to make one yesterday that was producing the results I wanted. Now today, after copying the...
August 30th, 2005 08:58 PM
by idgity Go to last post
2 267
#Name? error message by Andy[_5_]
I have this message in a box that calculates a value using values from a few other worksheets. Can someone tell me how to fix it. Thanks. #NAME?
May 9th, 2007 11:54 PM
by Andy[_5_] Go to last post
6 134
#Name? Error when using NETWORKDAYS function ...... by SeanAlexander
Hi, I'm creating a spreadsheet which is meant to calculate the number of days a person has worked between succesive weeks, given a specific start date and end...
September 8th, 2005 10:47 AM
by SeanAlexander Go to last post
2 164
#NAME? Error With User Defined Functions by Thomas M.
Excel 2007 I have a problem that has been driving me nuts. I created a code module and have pasted a couple of user defined functions into the module. When...
January 5th, 2010 02:39 AM
by Gord Dibben Go to last post
7 176
#num Error index, match by taxmom
I have a formula that the newsgroup help me with over a year ago. It worked perfectly and I use it though out my programs. However I want to use it in...
March 7th, 2006 05:40 PM
by taxmom Go to last post
3 117
#num error using IRR by Frank Situmorang[_2_]
Hello, Suppose I have money of IDR 300,000,- ( this is my money not a loan). Now I want to evaluate whether to Invest to build houses for rental. I have a...
August 19th, 2008 06:34 AM
by Frank Situmorang[_2_] Go to last post
4 103
#Num Error with Rate Function by antanas
I can't seem to get rid off the #Num Error when the Rate function is set up as follows: =RATE(360,599.95,10000,0,0,0.1). Iteration is turned on with these...
May 28th, 2005 02:47 PM
by antanas Go to last post
2 111
#NUM errors when calculating IRR by [email protected]
I am trying to calculate a few IRRs that are returning #NUM. I can't figure out why. I've been trying different guesses and I've been tweaking the number of...
May 4th, 2006 07:02 PM
by [email protected] Go to last post
7 169
#NUM! by Connie Martin
This is exhausting. I've surfed and surfed for answers. None! I have a previous post, just two or three down from this one ("Need help with formula), but...
January 13th, 2010 10:19 PM
by Connie Martin Go to last post
1 105
#NUM! being returned instead of 0 or blank by The Countryman
I was told to use the formula below which allows the lowest number within a range to be displayed discounting any zeros, this works...
January 5th, 2007 06:22 PM
by Harlan Grove Go to last post
2 91
#NUM! error on CUMIPMT function by Sarah RK
Hello I am having trouble with a negative number on the CUMIPMT function. Here is the formula: =CUMIPMT(-0.37%/12,360,196022,1,6,0) On all other calculations...
October 29th, 2003 04:46 PM
by Kevin Stecyk Go to last post
3 393
#NUM! in Date field calculation by Rick
Great site for help! I have 3 cells. A1 is a date cell (formatted for date mmm/yy) in which I input a start date. A2 is a numeric value representing the length...
November 29th, 2005 10:31 PM
by Rick Go to last post
4 106
#ref by jengy1
iam currently using the below formula, if there is no data for a month i am getting the #ref i have tried adding ifserror to input a 0 if necesary but...
March 4th, 2010 01:31 PM
by Bob Phillips[_3_] Go to last post
1 117
#ref appears when selecting cell in other worksheet by v1v8
When entering "=" then selecting cell on another worksheet, then hitting enter, the result is that the cursor moves to the other worksheet and gives a...
October 23rd, 2007 05:27 PM
by v1v8 Go to last post
0 72
#REF error in named formula by Gene
I have several worksheets in a workbook. I have ABX and XLNX as the first and last worksheets. I have incorporated ABX:XLNX!J14 to reference cells in each...
November 25th, 2007 12:18 AM
by Dave Peterson Go to last post
2 81
#REF Error in Named Range with INDIRECT, SUMPRODUCT, and OFFSET by Greg in CO[_2_]
Hi All! I have run into an odd issue using a Named Range with INDIRECT, SUMPRODUCT, and OFFSET. I have a worksheet that has a formula which will look for...
October 13th, 2008 06:45 PM
by Greg in CO[_2_] Go to last post
6 93
#Ref error question by TimN
I have a problem with a formula. Here is a very simplified version: I have a worksheet set up with monthly sales of product A and B. I use this worksheet to...
July 31st, 2006 02:31 PM
by TimN Go to last post
2 102
#Ref error when using vlookup formula by neil
I am getting a a #Ref error with the following formula. The lookup value is within a pivot table and the lookup range is...
May 14th, 2007 08:35 PM
by Naraine Ramkirath Go to last post
2 133
Post New Thread


Display Options
Showing threads 201 to 220 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:11 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.