|
|
Basic Formula rules by
Stan
How does a complete beginner go about creating a formula?
Is there a list of what each letter & symbol represents and how & where to
use them?
So far I have...
|
|
2 |
98 |
|
|
Increase the number of the invoice by
John B
Hello to everybody,
I have an invoice template almost finished and I would like to add a button
that increase the numer of the invoice of 1.
How may I do...
|
|
1 |
240 |
|
|
timesheet with running totals of overtime by
kimmyrt
Hi, I'm trying to create a very simple time sheet by weeks, not days. column
A is employees name, B is the week worked, C is total hrs. for that week, D
is...
|
|
2 |
184 |
|
|
How do I auto fill formulas by
dorheldav
In the past, I could create tables where I entered formulas in 2 cells then
dragged the handle down and Excel would autofill the formula in the...
|
January 25th, 2005 02:48 AM
by CLR
|
1 |
83 |
|
|
Adding values for prior date intervals by
Qaspec
In cells d7:D36 I have dates. In cells e7:E37 i have corresponding point
values. I can use sumproduct to provide a value for the last month from
today. I'd...
|
January 25th, 2005 02:49 AM
by Qaspec
|
1 |
89 |
|
|
Weekend days other than Sat Sun by
rkk
I need one more argument in Networkdays function after Startdate and Enddate,
weekend day or days in form of 1,2,3,4,5,6,7 before holdays
Any solution
Thanx
( 1 2)
|
|
15 |
214 |
|
|
|
|
4 |
243 |
|
|
|
January 25th, 2005 04:15 AM
by Roland
|
1 |
222 |
|
|
No Gridlines by
HagLight
When I bring in a converted 123 File, I can not get the worksheet gridlines
to display. Any suggestions?
|
January 25th, 2005 04:29 AM
by Karl K
|
4 |
140 |
|
|
|
|
1 |
197 |
|
|
|
January 25th, 2005 04:49 AM
by Max
|
5 |
127 |
|
|
|
January 25th, 2005 05:15 AM
by Biff
|
1 |
108 |
|
|
|
January 25th, 2005 08:11 AM
by prakash
|
3 |
266 |
|
|
|
|
1 |
382 |
|
|
Sum If Multiple Conditions by
Grant
I need help with my formula. I am trying sum data based on multiple
conditions. I used SUMPRODUCT in the past to do this. Column F needs to
greater than...
|
January 25th, 2005 03:02 PM
by JulieD
|
3 |
291 |
|
|
|
|
1 |
165 |
|
|
Formulars by
med211
I there a formula to be able to take the total for 12 different worksheets
and put them on a different worksheet?
Tks,
Jeff
|
January 25th, 2005 03:34 PM
by JulieD
|
1 |
87 |
|
|
formula to combine cells using if/then by
Linda G
Primary First Primay Last Secondary First Secondary Last First Last
John Smith Debbie John & Debbie
Carl Overstreet June Overstreet Carl &...
|
January 25th, 2005 03:51 PM
by Linda G
|
2 |
126 |
|
|
sumif and array formulas by
Bruce
In the following formaula i am essentually summing a range if another range
in the same row = zero
=IF(SUM(CT2:CW2)=0,SUM(CW2:DH2),0)
My worksheet fill this...
|
|
5 |
165 |
|
|
|
|
2 |
149 |