|
|
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 |
|
|
|
|
5 |
444 |
|
|
Add column to existing pivot table? by
Sue
Hi there,
I'm running Excel 2000 and would like to add a new column
to an existing pivot table. This would be a new column
from the original datasheet. I...
|
|
1 |
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 |
|
|
"Cannot empty Clipboard" by
tiff
When attempting copy/paste, a message pops up that reads "Microsoft cannot
empty clipboard." However, my clipboard is empty. This is preventing me...
|
October 10th, 2005 10:18 PM
by tiff
|
0 |
444 |
|
|
|
October 30th, 2005 06:20 PM
by rodante
|
4 |
444 |
|
|
|
June 3rd, 2004 06:10 AM
by Don
|
0 |
444 |
|
|
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 |
|
|
|
|
1 |
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 |
|
|
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 |
|
|
|
|
0 |
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 |
|
|
Variable Print Area by
Terry Bennett
Thanks Greg but that doesn't work - it still prints on 2 pages.
"GJones" wrote in...
|
|
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 |
|
|
|
|
3 |
443 |