|
|
conditional formating limits? by
Todd
Can I put more than one if statement in a conditional
format?
I want it to turn a cells background yellow if one cell
has data and either of the other two are...
|
|
2 |
341 |
|
|
sql.request help by
Shutter
Hi there,
I am trying to look up data from a local (win) mysql database from directly
in a cell. The help files came up with the sql.request function. ...
|
|
3 |
92 |
|
|
|
|
0 |
170 |
|
|
|
|
0 |
422 |
|
|
Formula text showing instead of result... by
Yann St-Germain
Hi,
I'm using Excel 2000 (9.0.6926 SP-3) and I have the following problem:
I have the following formula in the cell B2:
=SUBSTITUTE(A2, "blabla",...
|
|
7 |
366 |
|
|
Lookup for worksheet name by
Anders S
Tom,
One way:
=3DINDIRECT("'"&A1&"'!B23")
HTH
Anders Silv=E9n
"Snay" skrev i meddelandet =
|
|
2 |
146 |
|
|
hours x rate calculation by
martin
I have a spreadsheet with two columns detailing hours worked, (i.e. from and
to) and I have then two columns that convert the hours into a number format,
and...
|
November 13th, 2003 09:28 PM
by martin
|
0 |
525 |
|
|
|
November 13th, 2003 09:53 PM
by Dan B
|
2 |
236 |
|
|
Adding months to a date by
Christine Abbey
I know that you can type in = A2(being a date field)+ 45,
and it will add 45 as the number of days and show the new
date.
Is there any way to add months?
|
November 13th, 2003 09:55 PM
by Dave R.
|
1 |
384 |
|
|
Devide value by 0 or "" by
Syd
How can I get a formula to show me the valid value in one
cell if the other cell contains a zero. Example: Cell A1 =
26, cell A2 = 0 or "".
Now to devide cell...
|
|
5 |
149 |
|
|
Count # Workdays b/t two dates? by
Jason Morin
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(C1&":"&D1)),3)5))
where C1 holds start date and D1 holds end date.
HTH
Jason
Atlanta, GA
-----Original Message-----
I...
|
|
2 |
178 |
|
|
Referencing different workbooks by
jimmy
I have two seperate workbooks that both contain
information. One workbook contains a user key followed
with other relevent information. The other...
|
November 13th, 2003 10:30 PM
by cmoore
|
2 |
230 |
|
|
|
|
1 |
253 |
|
|
insufficient memory by
John Nelson
When opening excel spreadsheets the system randomly will
display the following message: "Microsoft excel cannot
open or save any more documents because there...
|
November 13th, 2003 11:33 PM
by Jase
|
2 |
275 |
|
|
Copy formula problem by
AWilliams722
Hello,
I have used Excel long enough to know that when you copy a formula and paste it into another, it should calculate the formula. It seems that I have to...
|
|
0 |
649 |
|
|
EXCEL by
KEVIN
DOES ANYONE KNOW HOW TO GET A DATE FORMATTED TO MM/DD/YYYY
WHEN IT COMES TO YOU AS AN UNFORMATTED FIELD AS FOLLOWS
20031202 (YYYYMMDD)
THANKS KEVIN
|
|
3 |
110 |
|
|
My brain hurts... by
John Croson
I have two worksheets, one is zipcode:
A B C
data zip state
wi53202 =RIGHT(A2,5) =LEFT(A2,2)
giving me:
A ...
|
|
3 |
231 |
|
|
Function to figure vacation accrual by
Liz
Help!!! I currently have a vacation spreadsheet in which
I need to create a column to show vacation accrual per
month. Based on their length of service with...
|
November 14th, 2003 12:31 AM
by cmoore
|
3 |
277 |
|
|
|
November 14th, 2003 01:42 AM
by BLUEC
|
0 |
190 |
|
|
Moving to next row by
Brian.
I know there's probably an easy answer to this, but in my
Excel, if I enter data in several consecutive cells in a
row, the enter key will then take me back to...
|
|
3 |
88 |