|
|
|
October 30th, 2005 06:20 PM
by rodante
|
4 |
444 |
|
|
Formula not producing correct result by
Jerry W. Lewis
1270.588235 is correct. You probably have H13 formatted to hide the
decimal places, but its value is 42.35294118, not 42 (which would give
1260). Formats...
|
|
1 |
444 |
|
|
|
June 3rd, 2004 06:10 AM
by Don
|
0 |
444 |
|
|
XIRR vs. IRR by
Jen
I would like to know which function is more accurate to
use when calculating the IRR for quarterly cash flows. I
know XIRR is to be used for irregular cash...
|
|
6 |
444 |
|
|
|
|
1 |
444 |
|
|
|
|
1 |
443 |
|
|
Multicell Array Formula and List Question by
John Mansfield
I have data in the range A1:B5 as follows:
a 5
b 3
c 6
d 5
e 7
In the range E1:E5, I have added the following multi-cell array formula that
returns the...
( 1 2)
|
March 21st, 2005 01:36 AM
by Max
|
11 |
443 |
|
|
|
|
4 |
443 |
|
|
Excel formatting problem when pasting by
Bill
I have an Excel sheet with row and column formatting of different sizes and
some cells merged.
What I woul like to do is to copy the sheet 25 times below on...
|
April 4th, 2004 12:34 PM
by Mark
|
2 |
443 |
|
|
assigning a macro to a command button by
Steve
I am attempting to assign a macro to a command button I
have inserted in my worksheet. The online help in the
program says to right click on the button and...
|
February 11th, 2004 11:07 PM
by DME
|
3 |
443 |
|
|
Removing password protect workbook option by
Brian
I password protected a large, multi-tab workbook so that shared users would not alter the structure. Even though I have a long history of well-documented...
|
|
1 |
443 |
|
|
cannot copy and paste specific function by
Mary C. Lydon
I am trying to copy a function from the formaula bar and
paste it to each row and will not work for me. Everytime
I get something pasted it has added the row...
|
October 5th, 2003 01:07 AM
by RagDyer
|
2 |
443 |
|
|
Variable Print Area by
Terry Bennett
Thanks Greg but that doesn't work - it still prints on 2 pages.
"GJones" wrote in...
|
|
1 |
443 |
|
|
Far too many "IF"s for my own good by
Jim
My self-esteem is in the crapper; I simply cannot imagine being "good
enough" to help, darn it. Perhaps someone will recommend you try VLOOKUP.
--
Greeting...
|
|
8 |
443 |
|
|
|
|
0 |
443 |
|
|
#N/A by
Bob Phillips
thanks bob..that did it..thanks for taking time to help
-----Original Message-----
Steve,
=IF(ISNA(vlookup_formula),0,vlookup_formula)
--
HTH
|
|
0 |
443 |
|
|
|
|
1 |
442 |
|
|
Copying condition formatting cells only by
Richard Flint
I would like to know if there is a way to copy the
conditional formatting into from one cell to all the other
cells in the column.
However, the referenced cell...
|
October 21st, 2003 09:17 PM
by Felipe
|
1 |
442 |
|
|
Sumproduct clarification by
Walter Mayes
Various members of this forum have stated that the arrays used in
SUMPRODUCT must be the same.
Excel HELP says, under remarks, in part..."Array arguments must...
( 1 2)
|
|
18 |
442 |
|
|
how can deactive cells to input data by
Kaveh_Alborz
help me plz
if you see one of the templates like balance sheet in excel some of
the cells are deactived and users just input data in special cells.
so how...
|
|
1 |
442 |