Hello -
I have employees that have different number of business days they work.  I
need to be able to calculate when the employee has utilized a specific number
of business days specific to the days of the week they work and the number of

i have a colomn where each line has uses the formula
=IF(V4=0,SUM(E4/D4*X4),SUM(W4/V4*X4))
at the bottom i am trying to sum the answers
=sum(y4:y204) but some of the lines return #div/0! because there is no

OK Guys, I have multiple sheets in a book, where the master sheet contains
account Number | account Name | TYPE | Outlet Number
    1731                      Grand Phr        Chain       6
I want to move TYPE and OUTLET NUMBER to all the other sheets where the

I have a spreadsheet grouped by division and region.  Region is the inner
group an division is the  outer group
Column A             B          C             D             E
                            age    50-54     55-59      60&>

Q: There are 2 seperate files....File A and File B.  I am trying to extract
data from file A into a cell in file B.  The problem is file A's name changes
according to current date e.g. 20060404_A.xls for April 4th and 20060405 for
Apr 5th.  

I have several tabs (worksheets) representing purchases for a specific year.
There is one tab (worksheet) that is a Summary of all purchases for all
years.  How do I get Excel to automatically update the Summary worksheet
anytime one of the other worksheets are modified?

i have a data in a sheet of one page only and i take print of this sheet
on two pages to get large view. i want the same data on another sheet to
take a print on one page only.
it can be done by copy and pasting to other sheet and adjusting print

I am using Excel 97, and I frequently use if statements that put a blank
(i.e. "") in the cell display when the statement is true or in some cases
when it is false.  If I copy the column and paste special/values, the cells
that had the "", even though they look blank and no ...

After I save my worksheet, I want to save a copy to a floppy disk. When I
click on SaveAs, the hour glass appears and does not do anything. My computer
says it is sending the error to Microsoft, but I have not gotten any
explenation as why this is happening.

I have no idea what I am doing and only hope someone can help.  I a
trying to change lowercase to uppercase AND the formulas I see are
foreign language to me.  I had labels in Word and in order to updat
the label list I decided to shift the labels to excel, but all of

If I wanted to do a monthly NPV model rather than an annual one, do I
just divide the discount rate by 12?
I think the long hand formula would be ((1+r)^(1/12))
What data would I need to calculate a monthly NPV? Any help please.

OK Guys, I have multiple sheets in a book, where the master sheet contains
account Number | account Name | TYPE | Outlet Number
    1731                      Grand Phr        Chain       6
I want to move TYPE and OUTLET NUMBER to all the other sheets where the

21/3/2006
20/2/2005
answer must be
1/1/1

Hello
My file is myfile2006.xls In cell B2 I have the current year 2006. I
B5 I am trying to reference last years file [MyFile2005.xls]sheet1!B4
The formula that I am using

Ok here is the formula:
="Cost of Additional 1% "& SUM(K3:K17)
I am trying to get the Sum piece to show as currency. Any help is
appreciated.