Ok...Here goes. Finally got this really nice IF statement to work:
=IF(A2>(6/7), 1, IF(A2>(5/7), 2, IF(A2>(4/7), 3, IF(A2>(3/7), 4,
IF(A2>(2/7), -1, IF(A2>(1/7), -2, 0))))))
This is in cell B2

Is it possible to have more than one function assigned to a single cell?
I would like to have formulas on 2 different worksheets, both of which will
produce different results (only one will finally effect the critical cell),
with the possibility of the results from these different ...

I would like to summarise 20 sheets in the same workbook.
I have a list of data in column A and then 6 lists of totals in columns B to
G, on each sheet.
I would like to add together the totals e.g. all the totals in column B

In the fill series fill handle, there is monthly or yearly, but not weekly or
bi-weekly.
How can i set it up to enter a date series by week?

I have three clients that get billed at different rates, here is th
formula I have
=IF(contract=John,(J11*50)*B11),IF(contract=Willey,(J11*20)*B11),IF(contract=Ernst,(J11*500)*B11)
But I only get the rate for John?  Can anybody fix this?

HELP!
I need an array that will COUNT the number of occurrences of multipl
criteria across two columns.
Example:

I would like to substitute 3 different characters in my cells.  I have
=SUBSTITUTE(A1,"/","")....but I would also like to substitute "-" and "&" for
"" all in the same formula.  Can it be done?  Thank you.

i need a formula that determines :
if # of years employed is greater than or equal to 1, then contribution is
equal to percentage multiplied by salary; otherwise contribution is zero

i need an if formula that does the following...if a grade is 60 or greater
add 5 points, if the grade is between 50 and 60 add 10 points, if the grade
is below 50, make grade 60

My first post here as i am very stuck with a very complex formula.
-=See attachment=-
Please if you can help grab the attachment so you know what i am o
about.

how can I use the COUNTIF formula to count only those numbers that fit
between a range like greater than 90 but less than 100.

I'm trying to do an employee timesheet.
I need to be able to enter a starting time / lunch in / lunch out / an
ending time. The fifth cell in that row needs to show the total hours
(minus lunch) with overtime in the sixth cell (hours over 10 hours).

I want to use the IF function, well any function that will make thi
work.  I am generating a list and want to make it easier to shade th
cells so my formula that works for producing the word and not th
colour goes like this.

I need help in figuring this one out.  I have 3 columbs, A, B and C.  'A' is
the dollar amount 'B' is the status and 'C' is the department.  Now, I want
to have the sum in Cel A50 all dollar amounts that are 'paid' and in '4045'
then in Cel B50 all dollar amounts that are 'paid' ...

I have created a workbook with an extensive custom menu. I now need to
transfer the workbook to another computer to be used elsewhere. When I
transfer the file using a pen drive I can open the workbook on the traget PC
but the custom menu has not been transfered and cannot be ...