|
|
"Text Limit" by
Don
Is there a limit as to how much text can be written in a
single cell? I've got a rather lengthy statement that I
tried to put into one cell but when I looked...
|
|
2 |
256 |
|
|
"Today()"???? by
Don
I've got the Today() function on an Invoice sheet. I
need to have the date automatically put on the Invoice,
which that function does. But, I need to lock in...
|
|
3 |
217 |
|
|
|
|
1 |
87 |
|
|
"Vlook up + IF" by
paula smith
I have created a function "vlook up" which worked fine,
however I would like to add the function "if" to avoid
have some cells N/A instead of a number...
|
November 28th, 2004 03:20 PM
by Rob
|
2 |
181 |
|
|
"VLOOKUP??" by
Don
Hi All,
Is it possible to pull data from another sheet using the
VLOOKUP function? I've looked at "Indirect", but that
seems to rely on typing in the name of...
( 1 2)
|
|
12 |
228 |
|
|
"weighted" average function ? by
carl
I am trying to determine the 'weighted' average profit for my trades.
My data looks as so...
Contracts Profit
5 .01
5 .04
2 ...
|
September 18th, 2004 02:15 PM
by duane
|
1 |
255 |
|
|
"Workbook" file by
WayneB
Hi: where can I fine the "workbook" file/template that appears when I click
on templates in "On my computer". I found the other templates in...
|
|
1 |
104 |
|
|
"YIELD" function by
Ray Moore
My old version of Excel (in Office 2000 Small Business)
had a function called "YIELD" which calculated the yield-
to-maturity for a bond, given the coupon...
|
|
4 |
164 |
|
|
# in Function by
CIL
Top of the morning.
The below function inserts a space between the last 2 digits of a number.
6789 in a1 becomes 678 9 and aligns on the left of the cell...
|
July 3rd, 2006 06:30 PM
by CIL
|
4 |
99 |
|
|
# mark by
help
# appears in my cells when numbers should appear
|
|
2 |
109 |
|
|
# of days in month by
dipsy
I know the month and want a formula that will tell me number of days in the
month. For example, April would be 30 days and May would be 31 days.
|
|
8 |
141 |
|
|
# of Functions per cell by
SUB-ZERO
Hi
Is there any way to change the number of functions allowed in each cell?
I have a spreadsheet and I need it to handle more functions than 7.
10-15...
|
|
3 |
434 |
|
|
# of iterations by
Rick
I am trying to figure how many iterations it takes 100 to go below 50 with a
decay rate of 20%. i.e. 100-(100*.8)=80 then 80-(80*.8)=64...and so on. I
am...
|
|
1 |
78 |
|
|
# of occurrences by
gbeard
Is it possible to count how many times a space occurs in a cell? If I could
count the words in a cell...that would work as well.
Thanks,
--
Gary Beard
|
|
1 |
116 |
|
|
# of recent documents by
Meebers[_3_]
WinXPMCESP3/Office07, under options for Excel, I have "Show this number of
recent documents =17", yet only 1 or 2 show at the most. I work on at least
15...
|
|
0 |
104 |
|
|
# of Worksheets by
Jeanne
How many worksheets can be used in one Excel file?
|
|
1 |
99 |
|
|
# sign showing up in cells by
Patricia
Everytime I try to type in the amount $17,700.71 all I get
in the coloumn is ############ signs. What can I do to
correct this?
|
October 29th, 2003 05:27 PM
by Dave R.
|
1 |
301 |
|
|
|
|
2 |
121 |
|
|
## by
Tracy
Does anyone know when summing a column say from cells h4-
h60, why I keep getting a ## for the sum? There is one
cell that is a text that should be excluded....
|
July 26th, 2004 04:59 PM
by
|
4 |
107 |
|
|
|
|
0 |
176 |