|
|
Convert Number to Words by
Siddhartha Neogi
Does MS Excel have any tool wherby a number can be converted to words, Eg.,
12345 be converted to Twelve Thousand Three Hundred and Forty Five etc.?
|
|
7 |
88 |
|
|
Concantenate columns with dates and text by
Dazed and Confused
The first two columns in my spreadsheet are dates. The third is text. When
I try to concantenate, the dates turn into numbers.
Any advice would be greatly...
|
|
2 |
57 |
|
|
Help with Function/Formula Overloads by
Rob
Hello....
I was wondering just how much Excel 2003 can take with regards to massive
amounts of Functions/Formula? I have a workbook and two worksheets have...
|
|
5 |
74 |
|
|
|
|
6 |
70 |
|
|
Adding X# of minutes to time (HH:MM:SS) by
Stuck Again
I have a long list of times in formatt 10:23:45 (HH:MM:SS). How do I add X
number of minutes to these times?
Ex: 10:23:45 add 4 minutes
Thanks for the...
|
|
2 |
45 |
|
|
Using the IF fuction for multiple cells by
Mike
Can anyone help me correctly write an IF function for multiple cells? Here is
an example of what I am needing help with:
A2, B2, C2, D2 are all yes or no...
|
|
4 |
68 |
|
|
Unexplainable XIRR #NUM! Error by
Jay
I have this great model to calculate project returns, really flexible in lots
of ways. I have an amortization table for project loans and I can change the...
|
|
3 |
80 |
|
|
AVERAGEIF by
Tung Nguyen
I have a worksheet like:
162-1
162-2
162-3
163-1
163-2
..........
I 'd like to average the group of cells with the same first three digit? I
am thinking about...
|
|
3 |
63 |
|
|
Difficult Formula lookup by
nelly
Hi folks
Here is a cut down version of a lookup im using to find the best choice for
a customer, as you can see from the row that starts 30 the customer...
|
April 4th, 2009 12:11 AM
by Elkar
|
4 |
60 |
|
|
|
|
1 |
52 |
|
|
|
|
7 |
87 |
|
|
|
|
3 |
106 |
|
|
find duplicates in list by
Ann
i have a single column of data. how do i highlight the duplicates in the
list. i've tried conditional formatting and can't get the formula right.
some...
|
|
3 |
50 |
|
|
Can I have two conditions in a SUMIF? by
trant
OK Thanks to the help of members of this board I learned to use SUMIF to sum
the values of a column based on a condition... but what if I have multiple...
|
April 3rd, 2009 09:11 PM
by Elkar
|
5 |
110 |
|
|
Difficult formula by
Connie Martin
I have this formula that is working great, but I need to expand on it and I
have no idea how:
=IF(H123="","",IF(H123="Not...
|
|
4 |
59 |
|
|
|
April 3rd, 2009 09:04 PM
by ToddS
|
2 |
57 |
|
|
|
|
2 |
70 |
|
|
#N/A error with Yield formula by
Eddie
Hello all, I have a someone sharing excel 2007 spreadsheets with others using
excel 2003. She is saving it in the 2003 format and everyone has the
neccesary...
|
|
7 |
117 |
|
|
|
April 3rd, 2009 07:44 PM
by Mike H
|
1 |
86 |
|
|
|
April 3rd, 2009 07:17 PM
by trant
|
4 |
61 |