|
|
|
|
0 |
96 |
|
|
|
|
5 |
119 |
|
|
Formulas dont uppdate automaticly? by
//R \(Swe\)
I have a cell M95 wich contains this formula =K95/L95*100
I writes numbers in the cells but on some PC's it dont do
the calculating. WHY?
There is same...
|
June 24th, 2004 09:37 AM
by Andy B
|
1 |
88 |
|
|
|
June 3rd, 2005 12:52 PM
by Hopest
|
5 |
85 |
|
|
Any function for Crop/Cut Text by
0-0 Wai Wai ^-^
Hi.
How can I do the following:
- crop text from the left
eg: CropText(A1, Crop3WordFromLeft)
- crop text from the middle
- crop text from the right
- crop...
|
|
1 |
93 |
|
|
Start & End of the data series by
0-0 Wai Wai ^-^
Is it possible to do the following:
When I paste this formula beside the data series, it detects:
- the upper & leftmost cell as the start of the data...
|
|
0 |
59 |
|
|
|
|
8 |
122 |
|
|
Variable Cell Reference by
0-0 Wai Wai ^-^
Hi.
I have forumlas which reference to a lot of cells, eg:
=...A1, ...A1, ... A1+A$2-$A3...
....B1, ...B1, ...B1+B$2-$B3...
.... ...
.... ...
Is it possible...
|
|
2 |
89 |
|
|
Variable Cell Referencing by
0-0 Wai Wai ^-^
Hi.
I have forumlas which reference to a lot of cells, eg:
=...A1, ...A1, ... A1+A$2-$A3...
....B1, ...B1, ...B1+B$2-$B3...
.... ...
.... ...
Is it possible...
|
|
3 |
91 |
|
|
vlookup with variable col_index_num by
0-0 Wai Wai ^-^
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
Since my table is subject to constant change, I would like to know how to create
a variable...
|
|
2 |
185 |
|
|
If's conditions about matching by
0-0 Wai Wai ^-^
How can I code these if's conditions:
1)
If the first letter of the statement is "A" or number "2"
2)
If the second word of the statement is "join" or...
|
May 12th, 2006 06:27 PM
by Biff
|
8 |
93 |
|
|
Extract information from the list by
0-0 Wai Wai ^-^
Hi.
I think it's going to be difficult to satisfy my requests.
Anyway, I have a list of symbols in column A like the following:
00001 = xxx (it refers...
|
|
3 |
115 |
|
|
Invalid Formula with the use of Indirect by
0-0 Wai Wai ^-^
Hi.
I'm not sure why it causes the error.
The formula is:
=VLOOKUP(A1, INDIRECT($C$15), 2, 1)
=VLOOKUP(A2, INDIRECT($C$15), 2, 1)
=VLOOKUP(A3,...
|
|
5 |
146 |
|
|
If the cell contains..., do something (2) by
0-0 Wai Wai ^-^
Hi.
Here's my original question:
1)
How to do the following:
a) If the cell starts with "senior", do something... (eg count that cell if the
cell starts with...
|
|
6 |
95 |
|
|
Advanced Lookup (lookup for 2 values) by
0-0 Wai Wai ^-^
Hi.
I have a worksheet which contains Risk Level & Profit Level.
Row A contains risk number. Column A contains Profit number.
Different risk number & profit...
|
|
2 |
77 |
|
|
If the cell contains..., do something by
0-0 Wai Wai ^-^
If the cell contains..., do something
Hi.
1)
How to do the following:
a) If the cell starts with "senior", do something... (eg count that cell if the
cell...
|
|
5 |
75 |
|
|
|
|
3 |
88 |
|
|
Insert manual line break in formula by
0-0 Wai Wai ^-^
Hi
I have a formula which combines texts from several sources.
Eg:
="I am a "&A30&". You are a "&A31&".
However we don't "&A32&", nor "&A33&".
Except that, we...
|
|
1 |
101 |
|
|
Extract each item in the list by
0-0 Wai Wai ^-^
Hi.
The cell A1 contains:
Here's the shopping list: pig, dog, hamburger, chocolate..., beef. Please
purchase all of them. Thanks!
I would like to extract each...
|
September 8th, 2005 12:50 PM
by Stefi
|
2 |
150 |
|
|
Take fraction out of the figure by
0-0 Wai Wai ^-^
Hi.
I would like to extract the fraction part out of a number. For example:
1.5 - 0.5
23.45 - 0.45
25 - 0
Is there any simple way to do it?
Thank you.
--
|
|
3 |
83 |