|
|
#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 05:21 PM
by Bob
|
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...
|
|
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
|
2 |
272 |
|
|
#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?
|
|
6 |
134 |
|
|
|
|
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...
|
|
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 04:40 PM
by taxmom
|
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...
|
|
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...
|
|
2 |
111 |
|
|
|
|
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...
|
|
1 |
105 |
|
|
|
|
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...
|
|
3 |
397 |
|
|
#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 09:31 PM
by Rick
|
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...
|
|
1 |
117 |
|
|
|
October 23rd, 2007 05:27 PM
by v1v8
|
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...
|
|
2 |
81 |
|
|
|
|
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
|
2 |
102 |
|
|
|
|
2 |
133 |