|
|
|
|
1 |
119 |
|
|
Multi funtion worksheet by
Maria
I need to create a worksheet that would allow for me to send out a few sheets
for updating and then consolidating using new data
|
|
1 |
129 |
|
|
Compound Average Annual Growth Rate by
PatJennings
Can someone help define the formula to calculate the compound average growth
rate (CAGR) starting with an initial amount which grows or shrinks depending...
|
|
3 |
134 |
|
|
|
|
3 |
196 |
|
|
formula to drive plus or minus as operator by
Newsgal
We have a standard formula to show the variance of 2 totals (A1-B1 =
Variance). However, it only works when B1 is a positive number. Is there a
formula that...
|
August 5th, 2008 11:55 PM
by Newsgal
|
4 |
118 |
|
|
|
|
6 |
129 |
|
|
SUMIF criteria by
lkawecki
I want to add the numbers in a column that are in cells that are not filled.
I tried the formula: =SUMIF(A2:A5,"no fill") and got the result, 0. A2:A5 is
the...
|
August 5th, 2008 11:47 PM
by Max
|
4 |
184 |
|
|
|
|
4 |
120 |
|
|
|
August 5th, 2008 11:09 PM
by Olivia
|
4 |
213 |
|
|
Fill Color If Statement by
Elgee
Hi -
In a workbook I track project financials. IE: Forecast, Actuals, Variance
etc.
Cell A2= Forecast
Cell A3= Actuals
Cell A4 = Variance
I would love for...
|
August 5th, 2008 10:13 PM
by Elgee
|
3 |
155 |
|
|
Picking a cell that is next to a cell by
Chris
I have a worksheet: Column A lists the letters of the alphabet, column b is a
series of text data and column c is numerical data. i.e.
A B C
A ...
|
|
4 |
151 |
|
|
|
August 5th, 2008 08:44 PM
by Spiky
|
1 |
94 |
|
|
|
|
2 |
90 |
|
|
Multiple Fonts in Excel Equation by
HM
I've been trying to find a way to have more than one font in an equation but
have not been successful through Excel's help option. If anyone's been able
to...
|
|
1 |
96 |
|
|
using solver question by
jvc007
How do you perform and inclusive or test using solver. I need Y1 to equal 1
if x11 or x21 is greater than o and Y1 to equal zero if both x11 and x21
equal...
|
August 5th, 2008 08:26 PM
by Spiky
|
3 |
90 |
|
|
Linking worksheets, but exceptions by
Emily
I have a worksheet with columns A - W. Column P contains names of a
contractor. I want 7 more worksheets named the contractor names ( I can do
that), but I...
|
|
4 |
112 |
|
|
|
|
3 |
96 |
|
|
formula to add six months to date by
lonedove288
I haven't used Excel in a while but I need to figure a formula to change
dates by six month increments in several different columns. I can't, for the
life of...
|
|
3 |
85 |
|
|
|
|
10 |
151 |
|
|
VLookup by
Kimberly
I want to know how to do a VLookUp (I think that is the formula, I would you
use) with multiple criteria. For example:
If the supplier is George O'Days and...
|
|
2 |
66 |