Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
make a negative number zero
I'm trying to make a worksheet and I need any number over 60 to be equal to
60. Or how can I make any negative number a zero? Please help, I've tried everything!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
make a negative number zero
"Decopk" wrote in message
... I'm trying to make a worksheet and I need any number over 60 to be equal to 60. Or how can I make any negative number a zero? Please help, I've tried everything!!! Have your number in a1 and this formula i b1: =if(a160;60;if(a1<0;0;a1) You might need to use "," instead of the ";". ";" is the standard delimiter with Norwegian regional settings. Rgds Thomas |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
make a negative number zero
Are they just number constants, or the result of a formula. If the latter,
use something like =IF(formula<0,0,formula) or = MAX(0,formula) and =IF(formula60,60,formula) or =MIN(60,formula) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Decopk" wrote in message ... I'm trying to make a worksheet and I need any number over 60 to be equal to 60. Or how can I make any negative number a zero? Please help, I've tried everything!!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
make a negative number zero
If your data is computed via formulas you could add logic to your formulas
EX. IF(A1+B1<0,0,A1+B1) etc..... If your data is hard coded EX. 1, 5, -3, etc.... I think you would have to pick another area and/or worksheet and add formulas to it EX. IF(hardcoded data <0,0,hardcoded data) etc... Hope this helps. Thanks, Bill Horton "Decopk" wrote: I'm trying to make a worksheet and I need any number over 60 to be equal to 60. Or how can I make any negative number a zero? Please help, I've tried everything!!! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
make a negative number zero
You can't just "change a number from what it is to something else", unless
you run a macro after entering the numbers..........if what you are wanting to do is tailor the results of a formula, then =IF(SUM(A1:A3)<0,0,MIN(SUM(A1:A3),60)) Replace SUM(A1:A3) with the formula you are using.......... Vaya con Dios, Chuck, CABGx3 "Decopk" wrote: I'm trying to make a worksheet and I need any number over 60 to be equal to 60. Or how can I make any negative number a zero? Please help, I've tried everything!!! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
make a negative number zero
=MIN(A1,60)
=IF(A1<0,0,A1) Gord Dibben Excel MVP On Wed, 14 Dec 2005 11:05:21 -0800, Decopk wrote: I'm trying to make a worksheet and I need any number over 60 to be equal to 60. Or how can I make any negative number a zero? Please help, I've tried everything!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Negative Number Format () Not available | Excel Discussion (Misc queries) | |||
How do I make lines appear after entering a number in a cell? | Excel Discussion (Misc queries) | |||
Sum - show negative number? | Excel Discussion (Misc queries) | |||
thousand separator as indian style for negative number | Excel Discussion (Misc queries) | |||
how do i subtract a negative number | Excel Worksheet Functions |