|
|
Can you help me again? by
I'm using the formula below rather than getting blank if
the statement is false, I'm getting a zero, can you help?
=IF(-K17=K16,-K17-K16-K40," ")
|
June 19th, 2004 12:35 AM
by Llobid
|
4 |
162 |
|
|
IRR function by
When we calculate an IRR using the IRR function with
yearly and monthly cash flow payments we are getting very
different results. The monthly payments sum up...
|
|
2 |
137 |
|
|
Letter deleting in spreadsheet by
User has an issue whenever she tries to type the word "an".
For some reason the n keeps disappearing. Autocomplete is
turned on and we tried turning it off to...
|
|
3 |
153 |
|
|
Excel tabs by
Is it possible to have sub sheet tabs in a sheet tab
|
|
2 |
163 |
|
|
Number to text (Checkbook) by
could anybody tell me how to set Excel to write out a
number in English? I need a way for Excel to refer to a
number in one cell/worksheet and turn it into a...
|
|
4 |
213 |
|
|
Links to workbooks by
Several cells within different sheets of a workbook are
linked to cells in other workbooks. How can one readily
break these links, but keep the value shown...
|
|
1 |
173 |
|
|
Report Manager available with XP? by
Using Small Business 2002, I've discoverd I'd like to use
the add-in Report Manager. However on the download page,
XP is not listed as a operating system. ...
|
|
2 |
111 |
|
|
|
|
1 |
93 |
|
|
Remove custom menu by
I created a custom menu that loads when a workbook is
opened. This menu is needed only for this one workbook.
How, and where, do I write the code to remove the...
|
|
5 |
99 |
|
|
cursor movement by
HI
On moving my cursor in the cells of hte excel file the
whole sheet moves rather than individual cells. like when
i click to a cell instead of moving to...
|
|
1 |
113 |
|
|
excel with another reporting tool? by
hi,
I have only worked on vba macros where my input and output
is both excel. Using macros most of the time it crashes
and the end-user is then not...
|
|
2 |
239 |
|
|
Data Table by
I am not sure I understand what I want here.
The name of the item is Data Table.
My customer wants the following info to be completed:
Rate 3%
Investment ?...
|
|
1 |
147 |
|
|
|
June 29th, 2004 10:09 AM
by William
|
4 |
559 |
|
|
Macro to sort a predefined list by
I need to make a button on my excel sheet that will sort a pre-defined area
(A2:K103) on my sheet the same way as selecting the area manually and...
|
|
2 |
158 |
|
|
Text File Import by
When opening a text file in Excel, the Text Import Wizard
doesn't show and the file opens as blank with nothing in
it. Any ideas?
Thanks,
- Andrew.
|
|
1 |
161 |
|
|
Initilizing the VBA libraries (126) by
I was wondering if someone could help with the following
problem:
I run Excel 2000. I have never in the years had any
problem but I want to open a file that...
|
July 8th, 2004 10:24 PM
by mzehr
|
1 |
164 |
|
|
Matching by
Hi,
I need the new table to fill in automatically from the
another table.
A B C
1 FRUIT COLOR AMOUNT
2 apple green 100
3 apple green ...
|
|
1 |
199 |
|
|
|
|
2 |
158 |
|
|
Saving Workbook in 'All Users'; 'Desktop' by
I've save a workbook that all users need to keep updated
in the above location. Seems to work OK except that every
time the workbook is saved, a new copy with...
|
|
1 |
122 |
|
|
|
|
6 |
224 |