|
|
Ensure accurant entry by
PCOR
I have to input a great deal of data in an Excel spreedsheet
One of the col is the person's phone number.It is VERY important that the
number be entered as...
|
|
1 |
327 |
|
|
SumIf where sum_range contains text by
Andreas
Hi!
The sumif function returns "0" if a cell to be added is a string value.
Is there a way to return the string (or error) and not a zero?
Cheers,
Andreas
|
|
4 |
137 |
|
|
|
Conditional summing question by
Steve Conway
thanks for your responses:
Each column heading is the "named range"
Col A Col B Col C Col D
program type ...
|
November 14th, 2003 10:50 PM
by sconway 
|
7 |
327 |
|
|
|
Help: Calculating loan payments by
Vernon
I have managed to use the PMT function to calculate the payments on a fixed
rate loan, I am however stumped at how to work out the payments on one of
these PCP...
|
November 14th, 2003 10:39 PM
by Anders S
|
1 |
331 |
|
|
|
populating cells using rank in other sheet by
Mark Graesser
You could insert a column in front of your existing data and populate it with the RANK numbers. Then you can use VLOOKUP to extract the specific ranks you...
|
|
1 |
145 |
|
|
|
Repeating characters to fill cell width by
Jen
I am trying to figure out how to input a character into a
cell and have it repeat the complete width of the cell.
In other words, it won't matter how wide the...
|
|
3 |
303 |
|
|
|
|
|
1 |
500 |
|
|
|
Formating Text/numbers by
bh
I want to be able to type in the follwing in to excel:
001234
0123
12323458
000032
And have the Zeros stay in place and have different length
in number- I...
|
|
2 |
110 |
|
|
|
How to read values off graph? by
Connie
I am having a problem reading values other than the plotted values off the graph.
For example: Values plotted for x=30, x=50 are y= 2 and y= 5 respectively but...
|
November 14th, 2003 08:41 PM
by Connie
|
0 |
252 |
|
|
|
Finding Last Relevant Cell by
Mae
This is probably more info than you need, and I'm sure
it's either a simple answer or impossible, but here
goes....
I have a workbook with worksheets...
|
November 14th, 2003 08:37 PM
by Mae
|
3 |
139 |
|
|
|
variable cell references in function by
Dan Condie
I need to change the number of cells being added depending
on the number entered into cell A1.
For instance,
If cell A1 says 10, I want cell B1 to...
|
|
2 |
418 |
|
|
|
Formula Question - Multiply with Divide by
Kele
Hello. Here is my problem:
In cell G4, I have this formula =+D4*F4.
D4 contains the number 356 and cell F4 gets its number
from this formula =+B4/E4.
G4...
|
|
2 |
302 |
|
|
|
retrieve disk space by
Ryan
Hello,
Is there a function in Excel to send the total disk
space, available disc space, and used disc space from the
computer to a cell? I found the info()...
|
|
1 |
537 |
|
|
|
formulas by
Louise
Dear all
I have a column of cells containing figures and have done
a simple autosum at the bottom of the column. However,
depending on what the answer is, I...
|
|
2 |
108 |
|
|
|
text wrap problem by
Jack
When using text wrap in a cell in Excel, the text entered
will wrap properly then suddenly, text will disappear,
other text will start appearing in the middle...
|
November 14th, 2003 05:33 PM
by Jack
|
0 |
457 |
|
|
|
formula by
[email protected]
I am creating a FV of money table;
F = (1+r/100)n
where n represents number of years; however n is an
exponent (ie. to the Nth power) How do I input...
|
November 14th, 2003 05:26 PM
by Paul
|
1 |
120 |
|
|
|
|
November 14th, 2003 04:29 PM
by Paul
|
3 |
326 |
|
|
|
Cell Reference Question by
Anders S
=3DINDIRECT("B"&A1)
HTH
Anders Silv=E9n
"hevner" skrev i meddelandet =
...
=20
...
|
November 14th, 2003 01:41 PM
by hevner
|
2 |
386 |
|
|
|
Formula by
SalEileen
In a cell I have "First Name Last Name" I would like to change this in the cell to
"Last Name, First Name".
|
|
1 |
149 |
|
|
|
formula by
dave c
Could someone give me the formula to enter into a single
cell to calculate and add the VAT
ie I type 50 answer 58.75
|
November 14th, 2003 11:49 AM
by akyurek
|
1 |
91 |
