|
|
prevent div/0 error by
Austin[_3_]
I am building a gradebook with limited knowledge of Excel. To get a weighted
percentage, I came up with...
|
|
2 |
197 |
|
|
|
|
4 |
197 |
|
|
Compound Interest Rate or Growth Rate by
1944-71222
Is there a function in Excell that can be used to calculate an investment"s
compound growth rate? If so what is it and how do you use it?
For instance if...
|
|
2 |
176 |
|
|
slow worksheet by
rylie14
why does it take so long to open an existing worksheet
|
|
1 |
185 |
|
|
Macro question by
Tina
I need a macro that will add the text -0000 at the end of whatever text is in
that current cell.
For example Cell = 75154
I need to add -0000 at the end...
|
|
2 |
184 |
|
|
Help with formula by
Corey[_4_]
I have data readings on a worksheet in cells B3:AF12 (10 rows deep x 31
columns wide).
I also have a date in cells A3:A12. One date for each row of data that...
|
|
0 |
212 |
|
|
Printing Worksheet by
GANTRYMAN
Is it possible to print a worksheet which shows the cell nos and row nos. If
you check the comment box which sais " show comments at end of sheet" it
states ...
|
|
1 |
178 |
|
|
Why does it display #### in my cell? by
Lindsey-Star
In cell I25 I have the following formula: =SUM(I11:I14)
All it displays is #####, but when I hover over it, it gives me the correct
answer on a popup...
( 1 2)
|
|
14 |
598 |
|
|
Lookup for this? by
Zakynthos
Hi,
In col A I have numbers 1 to 500 in sequential order
In column B, I have values against each of these numbers
In column C I have numbers 1 to 500 in...
|
|
2 |
171 |
|
|
sumif by
Robb27
I need to sum two cells together as long as either of the two cells have
numbers in them. If either of the two cells has "A" in it, then I need to...
|
|
1 |
119 |
|
|
converting an .xlsm file to .xml? by
Janis
how do you save an .xlsm file as .xml?
the excel files are simple files with cells with no calculations.
the records are county property records with some...
|
|
1 |
195 |
|
|
|
|
1 |
130 |
|
|
Calculation Question by
Scott
I have to calculate total tax based on a graduated scale. Let's say I make
$15,000 (in cell A1) and I want to calculate tax in one cell (in cell B1).
The tax...
|
|
2 |
148 |
|
|
Check to see if a value exists in a list? by
Pradhan
Hi and thanks again for your help out there...
Is there any function to test if a particular value exists in a list?
A simple example: Column A1= car;...
|
|
4 |
163 |
|
|
|
|
8 |
207 |
|
|
concantenate then index match by
Robb27
Hi.
Is it possible to concantenate one cell with text with another cell with a
number in it and take that result and then use it in an index/match formula...
|
|
2 |
106 |
|
|
|
|
3 |
137 |
|
|
count nonblank cells by
Art
I have a column B9:B100 on Sheet 1 in Excel 2007 in which each cell includes
a formula (=Sheet2!A9). The results of a search appear on Sheet2, then appear
on...
|
|
3 |
224 |
|
|
|
|
8 |
180 |
|
|
SUMIF (SUMPRODUCT?) with two arguments by
Max
Something like this should work ok
In M3: =SUMPRODUCT(($A$3:$A$100=L3)*($B$3:$B$100="Tom"),$C$3:$C$100)
Real dates are assumed in col A and in L3, real numbers...
|
March 14th, 2010 07:47 AM
by Max
|
0 |
130 |