|
|
|
|
0 |
132 |
|
|
Forecast IF Error Formula by
Denver
Hi,
I have this formula in my excel worksheet
FORECAST(COLUMN(),$AF4:AH4,(COLUMN($AF1:AH1)))
I want to add the IF(ISError) formula from the above forecast...
|
June 21st, 2009 07:05 AM
by Denver
|
2 |
160 |
|
|
|
June 21st, 2009 03:06 AM
by FSt1
|
1 |
146 |
|
|
|
|
3 |
151 |
|
|
|
|
3 |
140 |
|
|
含有計算公式的文*句* by
rg88
如何在同一個cell裏面,寫上含有計算公式的文*句*,而這文*句*裏的數目會隨著輸入的數**據該公式更新?
|
June 20th, 2009 06:07 AM
by rg88
|
0 |
147 |
|
|
General ledger spreadsheet continued by
Mark C[_3_]
My specific problem is when my spreadsheet contains calculated values for
example: PAID =F5+I5+L5+O5+R5+U5+X5, where PAID is the title of a column and
all of...
|
|
1 |
165 |
|
|
sumproduct with partial charcter matching by
Matt
I'm trying to achieve the following summary based on the data in the 'Data
table' below. I require assitance to construct a sumproduct formula that will...
|
June 20th, 2009 03:30 AM
by Max
|
3 |
151 |
|
|
Can I use NOT with COUNTIF? by
JALunceford
Can I use NOT with COUNTIF?
I have a column with values of "Complete" an "Not Complete". I don't want
to add the "Not Complete" in the count. I've racked...
|
|
6 |
148 |
|
|
lookup same or similar by
NeedToKnow
Hi all, I have tried to search old messages without luck.
I have 2 files which has column A = Vendor name, col B = order value EUR,
C-f = other data. I need...
|
|
3 |
167 |
|
|
|
June 19th, 2009 11:41 PM
by RC
|
2 |
156 |
|
|
Prepending numbers by
Florian68
How do I prepend or add a number to the beginning of a series of numbers?
For instance, I have a 4 digit number, 1001, that I want to be 11001. This
is the...
|
|
2 |
111 |
|
|
Return value based on another vlaue by
Jesse
I am trying to search a list of names (1200 names) for an exact match then
return back a department number. For instance if John Doe works in Dept. 10.
I...
|
|
1 |
133 |
|
|
Conditional Formulas by
Wendy
I need to know how I would write the formula for this function, if anyone
could help me that would be wonderful
If a number in a cell is between 1-15 then I...
|
June 19th, 2009 08:21 PM
by Wendy
|
6 |
133 |
|
|
Iteration by
Khalil
What is iteration and how to use it; please advise
regards
Khalil
|
June 19th, 2009 08:21 PM
by Khalil
|
4 |
116 |
|
|
formula to limit expenses to 1 of 2 values by
cynomolgous
My spreadsheet tracks expenses for faculty accounts. They are limited to
$700 for conference travel OR $500 for other research expenses.
I added a column for...
|
|
6 |
134 |
|
|
writing an formulae with variable parameters by
Formulas with variable parameters
I want to find the maximum (in each week) but along the years the first and
last position changes.
For that i use
"=MAX(D124:D1345)"
Now imagine that I...
|
|
2 |
121 |
|
|
#Value in random cells by
Michael
I have a formula to calculate the hours I work based upon time in and time
out - time in is deducted from time out. Since my time is based on two weeks
and...
|
|
2 |
117 |
|
|
General ledger spreadsheet by
Mark C[_3_]
I am in the process of developing a general ledger spreadsheet for my church.
The spreadsheet shows a list of the different funds in the church and I am...
|
|
3 |
117 |
|
|
Excel Spreadsheet by
Lynn
Can anyone help me with an excel spreadsheet using interest rate?
|
June 19th, 2009 06:07 PM
by Marcelo
|
5 |
123 |