|
|
how? by
HOW TO CONVERT $ TO INR ? BY APPLYING A FORMULA ?
|
September 22nd, 2003 03:13 PM
by Pierre
|
2 |
145 |
|
|
please help again by
Michael helped me with part of this earlier today. I'm
stuck again.
The below formula works well; however, I want to
add "(35200)" and "(35300)" to the...
|
June 9th, 2004 07:58 PM
by
|
2 |
123 |
|
|
|
|
2 |
135 |
|
|
filling series problem by
Sorry, other way around, I want it to fill like:
Sheet1 A1
Sheet2 A1
Sheet3 A1
but I get:
=(Sheet1!A1)
=(Sheet1!A2)
|
|
2 |
145 |
|
|
Difference by
In terms of funcionality what's the difference between
=SUMPRODUCT((A2:D2)*(A4:D20=1))
and
=SUMPRODUCT(($A$2:$D$2)*($A$4:$D$20=1))
This is with respect to...
|
June 22nd, 2004 10:26 PM
by TN
|
2 |
80 |
|
|
Autosum by
What ever happened to the Autosum button? Is this no
longer availl in excel 2000?
|
July 14th, 2004 08:26 PM
by Alan
|
1 |
149 |
|
|
PERSONAL.xls by
The above file is more of a nuisance than a problem;
however, it has been known to get very annoying. The
problem is that each time I open the Excel...
|
|
2 |
229 |
|
|
Sum of Degree Angles by
Does anyone know how to sum degrees, my degrees are in
cells. Example a1 105 52'08" a2 73 54'42"
Thank you!
|
September 5th, 2004 11:30 PM
by
|
3 |
117 |
|
|
|
|
2 |
296 |
|
|
please help with formula by
I tried the following formula and I should be receiving a
result of 0 because I7 has "(001234)" in it,
not "(00140)". For the record, K21 is greater than...
|
|
1 |
104 |
|
|
sumif; conditional sum by
I'm trying to get a conditional sum based on the relation
of the cells in the column to be evaluated to a fixed
cell. If the amount in the cell in the...
|
April 26th, 2004 05:39 PM
by Nancy
|
3 |
217 |
|
|
function by
i am not sure how to do this. I have a narray of numbers
in colum a (a4:a121) of either 1 or 2. In colum f (f4:f121)
is the same array. I would like a formula...
|
|
4 |
119 |
|
|
|
|
2 |
156 |
|
|
|
|
1 |
203 |
|
|
|
|
8 |
767 |
|
|
Formula not updating by
I entered a SUM formula and when I change the contents in
its range the total is not updated. Any ideas?
|
January 14th, 2004 02:00 PM
by Bingo
|
1 |
105 |
|
|
Slanting Cells in first Row by
I have a question for the Excel Savy crowd! I am looking
to change the first row in Excel by changing the cell
orientation. Actually slanting the cells! I...
( 1 2)
|
|
14 |
884 |
|
|
vlookup question by
hi
say i have colA and colB.
i m using vlookup (in other sheet) to lookup for values in
colA and returning corresponding value in colB. problem
arises when...
|
|
5 |
246 |
|
|
conditional sum if by
I just recently started using the conditional sum if
feature (array). I go through the entire wizard using an
existing spreadsheet. The last step of the...
|
March 31st, 2004 08:16 PM
by
|
8 |
154 |
|
|
Convert Number into Text by
In one column, I have numbers (120-1200). In another
column, I would like corresponding Alphabetical
representaion of the numbers.
Eg A1 = 123.56 then B1...
|
|
3 |
120 |