|
|
|
August 8th, 2008 04:25 AM
by cprao
|
3 |
75 |
|
|
|
|
1 |
87 |
|
|
IF function with too many arguments by
ahutyra
Thanks in advance for the assistance.
I am attempting to create a formula that will calculate a percentage of an
amount based on three different percentages....
|
August 8th, 2008 02:01 AM
by ahutyra
|
3 |
108 |
|
|
Problem with formula showing in cell by
andyK
I am having a problem with a excel document that I exported from a pdf file.
When I enter a formula in a cell the cell shows the formula continously. I
know...
|
August 8th, 2008 12:48 AM
by andyK
|
2 |
100 |
|
|
Referencing Error by
MikeChicago
I have a complex spreadsheet with many sheets linked together. Sometimes
when I delete rows on one sheet the links do not update. For example, if
cell...
|
|
0 |
82 |
|
|
|
|
1 |
88 |
|
|
Nested IF confusion! by
JayPee
Help needed for this newbie ... I'm using Excel2007 btw.
This is so simple but I just don't know why I can't get it to...
|
August 7th, 2008 11:33 PM
by JayPee
|
3 |
69 |
|
|
|
|
11 |
153 |
|
|
Reducing File Size by
Mike
I use an application called Hyperion to download information into an Excel
spreadsheet. The spreadsheet is initially loaded with formulas. At this time
the...
|
August 7th, 2008 11:23 PM
by Pete_UK
|
1 |
75 |
|
|
Formula Creation by
aleflore
I need to create a formula that will provide a result that calculates a date
three years out and another date one year out with the result being the
greater...
|
|
3 |
72 |
|
|
|
|
4 |
152 |
|
|
match by
robzrob
Trying to do a quite simple MATCH. In B53 I've got
=MATCH(E50,'SET-UP'!A1:M34,0)
E50 is a date, and there is a date exactly matching it in...
|
August 7th, 2008 10:51 PM
by robzrob
|
6 |
70 |
|
|
Mixing text and alpha in sumproduct arrays by
expect_ed
Just learning how to use Sumproduct to search for values. Looks like a very
powerful little function. But I keep getting a #VALUE! error when I have
text...
|
|
5 |
180 |
|
|
Another one! by
Connie Martin
Here's another one I've been mucking around with and can't get. In cell C7 I
want a formula that will look at the date in A7 and then go to A30:A1000 find...
|
August 7th, 2008 10:26 PM
by PCLIVE
|
3 |
67 |
|
|
How do I activate and inactivate worksheets? by
daughteroflight
I have 30 worksheets within a workbook, and want to summarize the information
found on them on the front worksheet. However, when I open the workbook, I
will...
|
|
3 |
82 |
|
|
|
|
1 |
85 |
|
|
extract numbers from a string by
Dave
Hello,
We import strings of numbers into a spreadsheet looking like
this:-
12Rev999,nextrev456
124Rev8888,nextrev1234
In practice the numbers can be any...
|
|
3 |
78 |
|
|
SUM PRODUCT FUNCTION by
Sue NY
I think I need to use the SUMPRODUCT function but need help w/ the formula.
Using the following data:
Investor Name Payment Due Date ...
|
|
5 |
88 |
|
|
Which function? by
Connie Martin
Which function and what formula would I use to add the number of the same
date in the column. If the date July 22 appears in a column 10 times, what
formula...
|
August 7th, 2008 09:09 PM
by Mike H
|
3 |
68 |
|
|
|
August 7th, 2008 09:07 PM
by Pierre
|
3 |
92 |