I have a Sheet (sheet 1) that changes each day based on TODAY() placed in C5.
My staff enter the beginning and end times of when they have completed a
specifc task.  A formula
(=IF(B12=JIM!$C$5,IF(JIM!$D$8="","",(JIM!$D$9-JIM!$D$8)),"") on sheet 2

I am trying to create a formula to do the following:
I have a data sheet that contains cost information.  The information
contains a project number and an account number.  I want a "nested lookup"
type of function that says, "If the project number equals X and the account

How do I write a function that only returns a value if the cell (A1) is of
the currency Euro. I assume the If function would be used. Here is what i
want it do.
=IF(A1 is currency EURO, *0.61,"")

My widget factory recieves orders from a distributor for production.  My
workers dont always produce the ordered amount.  My distributor has set up a
penalty clause as follows.
For up to 2 widgets or 1.5% of order (which ever is greater) he will accept

I want to reference 'Daily Reading Log' in the following formula, but keep
getting an error.  Where do i need to place the reference?
This formula is actually listed on the 'Summary" sheet, but the data for the
formula comes from teh "Daily Reading Log'

Good afternoon.  I know you can either use the concatenate function or the
formula =A1&B1 to combine cell contents.
However, if I am combining contents from 100 different cells, individually
selecting the cells become more cumbersome.

I need some help with a formula to calculate the total of monies collected by
Teams for a Relay. I want to make a Summary on one sheet based on data on
another sheet.
Team A has 15 members, Team B has 10. Money totals collected by members are

Hello. I am trying to format one cell based on the contents of
another. Specifically, I have a drop-down menu in D11, there are about
10 different text lines you can choose from. Five of them are phrases
relating to percentages and the other five are phrases relating to

Is there anyway to turn this feature off within cells?  In other words, I
want to drag the contents of one cell, Fall 06, for example, and keep that
value instead of Excel increasing the number by 1 with each successive cell;
07, 08, etc.

I have two sheets:  Master Log & Summary.  The master log contains many
rows, each having a date assigned to it.  The Summary sheet is used to sum
totals and present to the board.
I would like to create a sum formula in a cell in the Summary sheet, that

I am trying to create a formula, when a debit is entered, the numbers with in
the field will automatically populate in red with the brackets

Columnar figures were copied and pasted into my XL sheet from my USB VISA
online account.  I am unable to use the auto sum because XL does not read
them as dollar/numbers.  I have used the edit/clear/contents, and the
format/cells/categories/..., as well as using the $ in the ...

how do i transfer dada from one spread sheet to another

I am using a spreadsheet to track print jobs. One of the things I track is
the type of paper used and the cost of each piece for each job. Each paper
stock is assigned a stock code and has a unique cost. I want to be able to
enter the code and have the cost of the paper ...

Excel2003 ... Sample
Cell A2 ... Fred
Cell B2 ... 31
Range D5:D10 ... Various Names (people ... including "Fred")