|
|
IRR showed #NUM! by
bakbuk
I am trying to use IRR function for my string of cash flows for 10 years:
Year | Cash Flows
2009 | -272,895,028,812
2010 | -207,524,139,910
2011 |...
( 1 2)
|
|
16 |
327 |
|
|
|
|
0 |
266 |
|
|
|
May 1st, 2010 08:46 AM
by Sean
|
4 |
222 |
|
|
|
|
2 |
229 |
|
|
Maximum number of cells for 'SUM' ? by
Groybs
I have a spreadsheet with 56,314 rows of text labels.
I have a formula in each row off to the right of each text label. The
formula tests for a specific...
|
|
7 |
206 |
|
|
|
May 1st, 2010 03:47 AM
by Groybs
|
2 |
150 |
|
|
|
|
3 |
189 |
|
|
Conditional formatting problem by
Coco212
I KNOW I am being incompetent but must humbly plead for help:
cell p3 has the number 412 in it
cell t3 has the number 470 in it
I want p3 to be highlighted in...
|
May 1st, 2010 01:03 AM
by samrah
|
3 |
181 |
|
|
Logical Test for blank and then for score by
Mikesnhu
I am trying to score results
- M4 = test criteria (e.g. 5)
- O4 = test result (blank or a number .001 to 9999)
- P4 = scoring (if the result is blank, retun a...
|
May 1st, 2010 12:02 AM
by PatM
|
1 |
180 |
|
|
extracting data from one cell to another by
pat67
I have a sheet that i downloaded from our erp system that has one
column with text. the text is long and descriptive. the only thing is
the same is that there...
|
|
8 |
216 |
|
|
|
April 30th, 2010 11:40 PM
by Ormond
|
2 |
187 |
|
|
Count Multiple Text Entries by
Craig
Hi,
Following a post I did yesterday 'Count Text to get a Percentage'....my next
post is that I need to count text entries in differing cells to get a result...
|
April 30th, 2010 11:36 PM
by ker_01
|
1 |
172 |
|
|
Drop list and redirect by
WT
I have two workbooks W1 and W2, they both contain the same columns with the
same type of data. I know how to have W2 display the changed cell when W1 is
...
|
|
1 |
131 |
|
|
Sharing workbook by
Olivier
When i try to start sharing a workbook i get immediately the message:
"The file is no longer shared".
The file cant be saved anymore and so sharing is...
|
|
3 |
209 |
|
|
YES or NO formulas by
Alyssa
Hi,
I have a column that has a series of numbers it will always be either 10000
or 10100 , I want it to return a No for 10000 or Yes for 10100 in the field...
|
April 30th, 2010 10:16 PM
by FSt1
|
3 |
140 |
|
|
Sumif Function by
worduser
I successfully wrote a formula to give me the sum of one column (F) based on
whether or not column D has an "x" in it. It works fine in one spreadsheet,
but...
|
|
1 |
258 |
|
|
determine a range using a formula by
Jonathon Shull
I have a spreadsheet with budgeted financial data in columns, the heading for
each column is a 3 letter monthly abbreviation. Each month actual financial...
|
|
2 |
157 |
|
|
Need some help with auto-fill by
Per Carlsson
Im trying to get autofill to fill dates in batches of ten after each
other, but with little success.
like so...
Is there anyone who can help me with...
|
April 30th, 2010 05:02 PM
by Pete_UK
|
1 |
139 |
|
|
VBA to autofill from relative location by
AlexJarvis
If I need to autofill column B from the last cell that has data in it to the
same row as the last cell of column A that has data in it, how do I set the...
|
|
2 |
170 |
|
|
|
|
2 |
178 |