| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to calculate % using negative values | Excel Discussion (Misc queries) | |||
| Formula for Negative Values - ? | Excel Worksheet Functions | |||
| Negative values in a formula | Excel Worksheet Functions | |||
| how do i hide negative values in excel | Excel Discussion (Misc queries) | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
Linear Mode
