|
|
|
November 26th, 2005 07:01 PM
by bpeltzer
|
2 |
83 |
|
|
|
|
4 |
72 |
|
|
|
|
1 |
68 |
|
|
|
|
3 |
100 |
|
|
If Then Formulas by
ABSOLUTEMUSIC
I AM WORKING ON A FORMULA SO THAT IF J2 IS BETWEEN 0 AND 10 THEN I WANT
J3 TO DISPLAY 0.10 BUT IF J2 IS BETWEEN 10.01 AND 24.99 THEN J3 = 0.55
PLEASE...
|
|
6 |
197 |
|
|
Sum If ??? by
abuckeye
I want to sum column C if Column A is greater than or equal to 1/1/06 & less
than 2/1/06.
Any sugguestions?
|
|
4 |
72 |
|
|
|
|
1 |
115 |
|
|
|
|
3 |
102 |
|
|
|
February 24th, 2009 07:17 PM
by T. Valko
|
13 |
213 |
|
|
|
|
1 |
324 |
|
|
Counting cells between 2 values by
abxy
Basically, i'm trying to count the number of cells that have dates
between 1/1/04 and 1/8/04, but all the cells that are being counted are
in one colunm in...
( 1 2)
|
|
11 |
329 |
|
|
Printing only what can be seen by
abxy
Ok, I have a worksheet or template rather with about 200 rows (each row
size 14 font), each row (after the 7th row) has the same conditional
formats and...
|
|
1 |
136 |
|
|
Autoformatting...kinda? by
abxy
Ok, I've created a worksheet with some alternating shaded rows using
conditional formatting and formula is: =MOD(ROW(),2). and I've
customized some cells (the...
( 1 2)
|
|
10 |
180 |
|
|
Converting date to text by
ac
I would like to create a unique ID by combining Name & birthday.
For : Abc Def birthday 1/1/08
I would like it to read ADef010108. I can get everything...
|
|
2 |
101 |
|
|
Worksheet went grey! by
AC
Working in a 3-sheet workbook, the worksheet I was at suddenly went grey.
There are nothing to see, not event the grids. I can copy what was on the
sheet...
|
February 5th, 2009 12:18 PM
by Max
|
1 |
120 |
|
|
|
|
2 |
137 |
|
|
|
|
6 |
96 |
|
|
How can I remove a constant from a cell? by
ac
I have a spreadsheet that has been updated and now sent to me for formatting
and formula auditing but along the way someone entered in a constant variable...
|
April 29th, 2008 07:48 PM
by ac
|
2 |
102 |
|
|
Cannot check the check mark box in cell by
ac
I created the check mark box, renamed it, and then saved it off.
I basically want to use it for a survey, but when I go to click on the box;
it highlights...
|
|
1 |
70 |
|
|
LOOK UP AND SUM by
AC
I am trying to look through a list on names in one column and values in the
column next.
If I have a name that repeats I want to add all the corresponding...
|
|
2 |
125 |