timesheet - excess hours

I

iamhappyhaitch

I am looking for a formula that gives me a figure when a total exceeds a
certain figure.

what formula for " If (cell) exceeds 37 then (this cell) = ?
 
J

Jacob Skaria

If A1 > 37 100 else A1..You change 100 to a text string "YES" or to another
value

=IF(A1>37,100,A1)
 
P

Pecoflyer

iamhappyhaitch;343697 said:
I am looking for a formula that gives me a figure when a total exceeds
a
certain figure.

what formula for " If (cell) exceeds 37 then (this cell) = ?
Click to expand...

Maybe

=if(a1>37,anothervalue,a1)
 
I

iamhappyhaitch

Getting closer........I have a value of 39 in cell M35. I want the cell to
show the value above 37. i.e. I need the answer to be 2.
The formula you gave me, gave me a result of 1.625 ??
 
P

Pecoflyer

=if(m35>37,m35-37,m35)

I do not know where the 1.625 might come from


iamhappyhaitch;343743 said:
Getting closer........I have a value of 39 in cell M35. I want the cell
to
show the value above 37. i.e. I need the answer to be 2.
The formula you gave me, gave me a result of 1.625 ??
Click to expand...

HOW TO GET FURTHER HELP WITH A WORKBOOK
For further help with it why not join our forums (shown in
the link below) it's completely free, if you do join you will have the
opportunity to add attachmnets to your posts so you can add workbooks to
better illustrate your problems and get help directly with them. Also if
you do join please post in this thread (link found below) so that people
who have been following or helping with this query can continue to do
so. :)
 
Top