I use XL2000, but Office recently had to be reinstalled. I use Autosave, and
I leave it set to save without prompting. Before the re-installation, it
- Nov 18 Sat 2006 20:10
Problem with Autosave
- Nov 18 Sat 2006 20:10
IF, AND, OR Function help needed
I have an existing function that works.
=IF(AND(AL18=quot;Yquot;,OR(AM18=quot;Yquot;,AM18=0),AN18=quot;Yquot;)=TRU E,quot;Standard Pricingquot;,
- Nov 18 Sat 2006 20:10
Insert current author's name in cell or footer in Excel??
I have created a spreadsheet for my department to use to list their projects
for each week. Just wondering if there is an automatic way to have the
- Nov 18 Sat 2006 20:10
Is there an opposite function of SUM, like DIFF?
How do I get the Difference between f20 and f21 and use it in a formula. Say
f20's value is $17.27 and f21's value is $17.32 and I want to multiply that
- Nov 18 Sat 2006 20:10
Sumif function, nonadjacent cells
I need to pull totals from various places on the spreadsheet, and add them if
they are less than $0.00 to get the total amount owed. Is there any way to
- Nov 18 Sat 2006 20:10
How do I sum numbers in rolling format? (4 qtrs=4 cells to left)
I am trying to create a rolling total based on the previous 4 quarters. My
plan is to add a column to the left of the sum column. How do I sum the
- Nov 18 Sat 2006 20:10
TIME function
I am trying to create a spreadsheet with calculations for the various
times zones based on GMT. I use the function TIME(H,M,S). For
- Nov 18 Sat 2006 20:10
Sort command does not sort some columns?
When attempting to sort data, newly entered data seems to stay the same while
the old data sorts itself. I have one whole column that is now mismatched.
- Nov 18 Sat 2006 20:10
SUM of INDEX lookups
Here is my syntax for summing looked up fields. What it is doing is looking
up all downtime minutes in the Header sheet for shift 1. But I get #REF as
- Nov 18 Sat 2006 20:10
3 letter capitalisation