hide negative values from a formula
 

I am trying to make a simple form to log my weekly work hours. To calculate
OT and display it in a cell I made a formula but unless I have more than 40
hours that cell will display a negative number (=SUM(K353-40)). I was
wondering if any experts had a better way for me to do this.....

Maybe if I had a formual that displayed anything over 40 hours...but I am
not sure

hide negative values from a formula
 

Hi
=MAX(0,K353-40)

--
Regards
Frank Kabel
Frankfurt, Germany

Jack wrote:
I am trying to make a simple form to log my weekly work hours. To
calculate OT and display it in a cell I made a formula but unless I
have more than 40 hours that cell will display a negative number
(=SUM(K353-40)). I was wondering if any experts had a better way for
me to do this.....

Maybe if I had a formual that displayed anything over 40 hours...but
I am not sure

hide negative values from a formula
 

Hello
=IF((K353-40)<0,"",K353-40)
HTH
Cordially
Pascal

"Jack" a écrit dans le message de news:
...
I am trying to make a simple form to log my weekly work hours. To calculate
OT and display it in a cell I made a formula but unless I have more than
40
hours that cell will display a negative number (=SUM(K353-40)). I was
wondering if any experts had a better way for me to do this.....

Maybe if I had a formual that displayed anything over 40 hours...but I am
not sure

hide negative values from a formula
 

=max(SUM(K353-40),0)

--
Regards,
Tom Ogilvy

"Jack" wrote in message
...
I am trying to make a simple form to log my weekly work hours. To
calculate
OT and display it in a cell I made a formula but unless I have more than
40
hours that cell will display a negative number (=SUM(K353-40)). I was
wondering if any experts had a better way for me to do this.....

Maybe if I had a formual that displayed anything over 40 hours...but I am
not sure