|
|
Some problem with the Site???? by
Neeraja
Hi,
In the Community NewsGroups why i am unable to see the
updated information. The last question i can see is the
one posted on 17th Sep 2003 10.34pm.
Till...
|
September 18th, 2003 11:49 AM
by Robert
|
2 |
262 |
|
|
If then formula by
Biff
Hi Howard,
There are several ways to do this depending on how many
variables there are. Here's one way:
=CHOOSE(A1,400,375,325)
Whatever number you enter in...
|
September 18th, 2003 11:51 AM
by CLR
|
3 |
164 |
|
|
|
|
1 |
326 |
|
|
Converting ASCII comma delimited by
Billy the brick
I have a file from the Australian Bureau of Statistics
which is in excel, but is ASCII comma delimited.
None of the usual excel functions will recognise...
|
|
1 |
347 |
|
|
Preserve formula in cell by
Weatherall Ian D.
Hello All,
I am creating a scheduling workbook with 2 work sheets, the first sheet is
the schedule itself and the second is the availability. When a staff...
|
September 18th, 2003 12:02 PM
by Anon
|
1 |
118 |
|
|
Sum Dates by
SFrick
I have a spreadsheet with 8 years worth of data in col months. For
example row5 Col's C through CF have dates starting with the first day
of the month, like...
|
September 18th, 2003 12:26 PM
by SFrick
|
3 |
302 |
|
|
Counting fill color. by
Jeff
I'm trying to write a formula that will count a cell if it
has a certain fill color. For example, I have a range of
cells, A1:A3, where A1 & A2 are filled with...
|
|
1 |
281 |
|
|
Moving from textbox1 to textbox3 by
steve
Sorry if this is a stupid question I know its simple for you all.
But I want to use tab and return to move from one textbox to another. I
would like to choose...
|
September 18th, 2003 01:52 PM
by steve
|
4 |
233 |
|
|
auto matic date calculation by
satish
I have a date in cell (eg:1-Jan-2003).I want the next cell
to be date 3 calendar months away(1-April-2003).How do I
do this using a formula?
satish
|
|
3 |
377 |
|
|
Problem rounding up by
Tony
I have a result that needs to be rounded up such as
60.2 should become 61
When I format cells to whole number it rounds down.
I need to round up in all...
|
September 18th, 2003 03:04 PM
by Anon
|
2 |
210 |
|
|
Worksheet Prints by
Lori
I have selected all worksheets in a workbook to print. Now
I can't get the option off. I do not want to always print
this way. Help!!
|
September 18th, 2003 03:06 PM
by Lori
|
2 |
115 |
|
|
No More Custom Number Format ERROR by
James
I am working with a model in which I am converting to a
current scenerio. When I go into a specific cell to
change the link it gives me a error that reads "No...
|
September 18th, 2003 03:13 PM
by James
|
0 |
906 |
|
|
Tan Graph by
mr
I need to draw the graph of tan x, which involves the use of infinity.
Can anyone tell me either how to display the infinity sign or
alternatively how to...
|
September 18th, 2003 03:30 PM
by Dan E
|
1 |
257 |
|
|
Auto update of cells in worksheet by
Gerry
I have a workbook with 4 worksheets. The first worksheet
is to be a summary sheet that shows the status of a line
item as it moves through various stages. The...
|
September 18th, 2003 03:54 PM
by Anon
|
1 |
405 |
|
|
Conditional List by
Wayne Burritt
Hi: I have many records arrayed horizontally. I have a list of symbols in
column E, a list of dates in column G, and a "Yes" or "No" for each record
in...
|
|
1 |
225 |
|
|
If than statements....Help by
Kam
Hello,
I am having troubling making sense of creating if than
statements to work for my formulas in excel. Is there a
better guide than the one provided in...
|
September 18th, 2003 04:22 PM
by Anon
|
2 |
110 |
|
|
Excel Templates by
Elizabeth
I use excel to do quotes for my customers. I have about
100 or more masters. If I am to busy or not here someone
else will do the quotes for me. My problem...
|
September 18th, 2003 04:31 PM
by Andy B
|
1 |
285 |
|
|
NUMBER OF MONTHS in EXCEL CALC by
ROYB
Hi
I don't know what's happening - I posted the request below
yesteday, a few people very kindly replied with some very
good ideas - when I went back inbto...
|
|
1 |
228 |
|
|
Date Formula by
PD
I have a worksheet in which I keep information about
students (i.e., name, grade, disability, birthdate,
evaluation date). Every 3 years each student must be...
|
|
1 |
168 |
|
|
Movie Times Calculation? by
CAMooV
I work for a major theatre chain an no one (inclduing the help desk) can figure
out how to make a show start/end time schedule calculate the ending time. ...
|
September 18th, 2003 05:08 PM
by Charlie
|
3 |
8,767 |