I need to know how to get this column to say: If the hours worked are more
than 40 then take time and a half and multiply that times the difference
between the hours worked and 40 and in that same cell add the regular hour to
the overtime pay.  i've got it about 98% done but ...

I type in the following formula and keep getting the error message that it is
missing a parenthesis. No error message when using the "pop up" window to
assist with the formula but when I hit "enter" I get the parenthesis
notification.  However,  I have added them everywhere I can ...

A friend of mine asked me this question and I have no idea how to do this
Would there by chance be a function in Excel where you can choose a range of
cells with an amount in each cell and see if any combination of those cells
added up to a certain dollar amount?  Say, I have a ...

Is there a way to make a change in a workbook and have it automatically make
the same change in worksheets in the same workbook?

Is there any way to convert data that excel is not recognizing so that it is
in a uable form? For example if I copy data from a web report into excel. The
data goes into separate cells as it should but when I try to run a formula on
the data excel will not recognize the data. I ...

I will do my best in explaining what I would like to do. Thank you in
advance for taking time into figuring this out.  I have a file that keeps log
of all my employees updates in sales, streches, costs , mandates, clients  
and target achivement ect... I update this file every ...

I am trying to nest a sumif function but having trouble.
I have a spreadsheet that lists multiple cost/revenue types with multiple
business units.  I am trying to find a sum of a column for a given business
unit and cost/revenue type.

Very simple example of Data I'm working with:
Month    Store    Sales
1/31/2007    west    400
2/28/2007    west    100

I am working on a spreadsheet (excel 2002) showing work schedules (A or P).  
On the first sheet I have:
        17-Feb    18-Feb    19-Feb    20-Feb
Sue    RN    a    a    a   

I have a spreadsheet that I need to set up but I can't figure out if what I
want to do is possible...
The spreadsheet tracks clients that have 10+ deals outstanding with us and
tracks which person covers the client, how many trades there are, etc.

What am I doing wrong?
I know I have to do control shift enter for an array but I am receiving an
error saying my formula is wrong. Can I even so this?
Thank you.

I can't seem to figure this one out.
I have a sheet per check date and a summary sheet.  In "check date" sheet,
there are two columns, A=check amount & B= check mail date.  There can be
different amounts of rows per "check date" sheet.  

F17/(AVERAGE(C17,B17))*(12/(COUNTA(B5:B16)))
in B5:B16, I have this formula..
=IF(SUM(Start:End!B5)=0,"",SUM(Start:End!B5))
Now the problem is...the COUNTA function in the first formula above is

I want a cell to fill in a color if the result is positive and another
color if teh result is negative.
I can use the if - then function fairly well but I cannot figure out
how to get a cell to fill in a color based on the result.

I have a spreadsheet with 10,000 rows with this information;
Rows look like this,
R1 Ontime:   100.00%
R2 711 *OEM1676EN