|
|
How would I do this sum in Excel please? by
Denise Green
am new to excel (and maths to some extent!) so how do I put the following
calculation into the formula bar please.
42,450 x (1+0.004167) to the power of 120
|
|
7 |
379 |
|
|
|
|
4 |
471 |
|
|
|
|
6 |
285 |
|
|
Formula Values not Updating by
dcornett63
Hello,
I have a multisheet spreadsheet that keeps track of costs on jobs that
extend over multiple days (a worksheet for each day). This is something that...
|
November 13th, 2009 11:42 PM
by Luizvs
|
1 |
279 |
|
|
|
|
5 |
386 |
|
|
|
|
8 |
287 |
|
|
Average Time for Specific Item by
stkinkuwait
Thanks in advance for any help!
I am trying to calculate the average time it takes to accomplish a specific
task amongst many tasks during an 8 hour weekday,...
( 1 2)
|
|
10 |
428 |
|
|
use pivot table data in vlookup formula by
Jennifer Novato
When I copy the results of a pivot table to another worksheet, the vlookup
formula in the other worksheet does not recognize the same number from the
data...
|
|
0 |
252 |
|
|
BVE = BE? by
Todd
why is it when you type "BVE" onto a cell it changes it to BE?
|
November 13th, 2009 09:45 PM
by T. Valko
|
2 |
274 |
|
|
Problem with a simple formula by
ChristiW26
I've entered a simple "=sum" formula into a cell on a worksheet and for some
reason, the formula is being displayed in the cell instead of the value.
I've...
|
|
8 |
332 |
|
|
sumif based on 1 criteria by
v1rt8
cannot quite figure this out,
Cells a3:a1000 have respectively numbers 1-997
Cells f3:f1000 has text containing either of 4 types...
|
November 13th, 2009 09:26 PM
by v1rt8
|
1 |
233 |
|
|
MATCH with MAX formula question by
Spongie
I'm hoping someone can help. I have the following formula in a spreadsheet:
=IF(MATCH(MAX(C22:G22),C22:G22,0)=1,"Low...
|
|
5 |
212 |
|
|
averageif with 2 other criteria by
v1rt8
Need some help with an averageif calc.
setup is as follows:
q3:q1357 contains ages
r3:r1357 contains text (active), (MGT), (others)
so averageif q3:q1357...
( 1 2)
|
November 13th, 2009 09:00 PM
by T. Valko
|
10 |
479 |
|
|
Concatenate not working by
NicoleS
Using Excel 2007 - though I've seen this problem in '03, too.
I inserted a concatenate formula into a cell: =CONCATENATE(B3," ",A3)
Then I dragged the formula...
|
|
3 |
245 |
|
|
Resetting the scroll bar by
Todd
Lets say I have a spreadsheet with information going out to column FT and I
deleted the information because it was no longer necessary. Now my data only
goes...
|
|
1 |
237 |
|
|
|
November 13th, 2009 08:16 PM
by berniean
|
3 |
232 |
|
|
nested ifs by
dave glynn
Cell C1 takes is value from any one of three other cells depending on the
value of cell B4. The if statement I should like to writr would go something
like...
|
|
4 |
198 |
|
|
Count Names by
B. Levien
I have an excel spreadsheet with Columns like:
Column C Column D Column E
Award1 Award2 Award3
Row 1 Brenda Joe Shana
Row 2 Misty Joe Monty
Row 3 Brenda...
|
|
2 |
239 |
|
|
Splitting text and numbers from a cell by
JimAA
Hi,
I'm trying to split a cell that contains a part number and a part
description into a cell that contains the part number and a cell that
contains the part...
|
|
4 |
225 |
|
|
|
November 13th, 2009 07:07 PM
by KidA
|
3 |
323 |