|
|
Formula/worksheet error by
Kim
I have a large spreadsheet that I am trying to modify a formula in. Whenever
I make any change to the formula, rather than returning the result in the
cell,...
|
|
1 |
767 |
|
|
Time Formatting Question by
John Calder
Hi
I run Excel 2K
I download various times from a mainframe. When the come down they look like
this:
1:53:00 AM
When I try a custom format to convert this...
|
|
4 |
985 |
|
|
Production/Inventory by
I'm Stumped
I have a workbook that tracks inventory, but I would like to update it with a
formula to help me track the materials used to create my inventory.
Example: ...
|
|
4 |
820 |
|
|
|
|
1 |
821 |
|
|
|
April 18th, 2010 04:23 PM
by dean
|
0 |
816 |
|
|
|
|
4 |
874 |
|
|
SUM of a colum where IF function is used by
Vinay Vasu
Hi,
I would like to have the sum of cloumn 'C' in the attached file.
An IF function is used to derive column C.
=SUM ( C1:C21) is not giving the...
|
|
1 |
787 |
|
|
|
April 17th, 2010 12:58 AM
by JLatham
|
1 |
856 |
|
|
Showing Only Actual Typing Area ? by
Bob[_62_]
Hello,
Using Word 2007 and Windows 7.
I want to always have my documents set up in the normal, typical manner:
The paper size is 8.5x11
The margins are all...
|
April 16th, 2010 11:19 PM
by Ron@Buy
|
1 |
720 |
|
|
Average Function but exclude info by
Linda RQ[_2_]
Hi Everyone,
Excel 2003. I have a list of numbers. I use the Insert/Function then drag
the cells I want to create my formula for averaging this column. I...
|
April 16th, 2010 09:17 PM
by Mitch
|
4 |
829 |
|
|
|
|
3 |
881 |
|
|
Pivot Table calculated field error by
Lee
I have a calculated field in a pivot table in Excel 2007 that averages the
selling price of an item. The Columns are the years from 2008 to present,
Row...
|
April 15th, 2010 10:23 PM
by Lee
|
2 |
1,068 |
|
|
|
|
3 |
813 |
|
|
Calcualate Time by
hitesh
Dear
In A1 Customer Name In B1 Complaint Date In c1 Complaint Time in D1
Complaint Attend Date In E1 Complaint Attend Time. I want the Result in F1
Total...
|
|
4 |
763 |
|
|
if/or formula by
Barny[_6_]
I would like to return the result in cell K132 based on the following-
Cell K132 will return the result N or M when/if I132 = N or J132 = M
Cells I132 and...
|
|
2 |
865 |
|
|
|
April 13th, 2010 11:50 PM
by John
|
3 |
6,128 |
|
|
Row Numbering by
Uddhava
Sorry for newbie question...
I want the top of my columns to be titles for my columns eg January,
February etc then to have a space (eg a blank row) before...
|
|
1 |
842 |
|
|
Locking Fomulas by
Rahn
How can I lock the formulas in a woorksheet but allow others to add
information in it without deleting the formulas. (Excel Office 2007...
|
|
2 |
725 |
|
|
Quarterly Formula by
Caroline
Is there a formula to obtain a total for each quarter which excludes
including the year? Thus avoiding having to change to year on a yearly
basis. Your...
|
|
2 |
906 |
|
|
|
April 13th, 2010 03:58 PM
by JLatham
|
3 |
798 |