| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula/function that prints only positve numbers
I have a overtime worksheet, but I only want the computed totals above 40
hours to print in the Overtime column (not the negative numbers). Is there a formula-function that will provide such?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula/function that prints only positve numbers
Try the MAX function.
=MAX(A1,0) This returns the larger of the two values A1 or 0. Thus, if A1 is ever negative, 0 will be returned. You can substitute whatever formula you're currently using for A1. Another option, if you don't want 0's, is an IF Statement. =IF(A1<=0,"",A1) This states that if A1 (or your formula) is less than or equal to 0, return a blank (double quotes), otherwise return the value of A1. HTH, Elkar "Kara Hoover" wrote: I have a overtime worksheet, but I only want the computed totals above 40 hours to print in the Overtime column (not the negative numbers). Is there a formula-function that will provide such?? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula/function that prints only positve numbers
THANK YOU...THANK YOU...
"Elkar" wrote: Try the MAX function. =MAX(A1,0) This returns the larger of the two values A1 or 0. Thus, if A1 is ever negative, 0 will be returned. You can substitute whatever formula you're currently using for A1. Another option, if you don't want 0's, is an IF Statement. =IF(A1<=0,"",A1) This states that if A1 (or your formula) is less than or equal to 0, return a blank (double quotes), otherwise return the value of A1. HTH, Elkar "Kara Hoover" wrote: I have a overtime worksheet, but I only want the computed totals above 40 hours to print in the Overtime column (not the negative numbers). Is there a formula-function that will provide such?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
| VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
| How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
| How to sum top 5 numbers from the column of numbers | Excel Discussion (Misc queries) | |||
Linear Mode
