software

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!!!quot;Decopkquot; gt; wrote in message
...
gt; I'm trying to make a worksheet and I need any number over 60 to be equal
to
gt; 60. Or how can I make any negative number a zero? Please help, I've
tried
gt; everything!!!

Have your number in a1 and this formula i b1:

=if(a1gt;60;60;if(a1lt;0;0;a1)

You might need to use quot;,quot; instead of the quot;;quot;. quot;;quot; is the standard delimiter
with Norwegian regional settings.Rgds

Thomas
Are they just number constants, or the result of a formula. If the latter,
use something like

=IF(formulalt;0,0,formula) or = MAX(0,formula)

and

=IF(formulagt;60,60,formula) or =MIN(60,formula)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Decopkquot; gt; wrote in message
...
gt; I'm trying to make a worksheet and I need any number over 60 to be equal
to
gt; 60. Or how can I make any negative number a zero? Please help, I've
tried
gt; everything!!!
gt;
If your data is computed via formulas you could add logic to your formulas
EX. IF(A1 B1lt;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 lt;0,0,hardcoded data) etc...

Hope this helps.

Thanks,
Bill Horton

quot;Decopkquot; wrote:

gt; I'm trying to make a worksheet and I need any number over 60 to be equal to
gt; 60. Or how can I make any negative number a zero? Please help, I've tried
gt; everything!!!
gt;

You can't just quot;change a number from what it is to something elsequot;, 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)lt;0,0,MIN(SUM(A1:A3),60))

Replace SUM(A1:A3) with the formula you are using..........

Vaya con Dios,
Chuck, CABGx3
quot;Decopkquot; wrote:

gt; I'm trying to make a worksheet and I need any number over 60 to be equal to
gt; 60. Or how can I make any negative number a zero? Please help, I've tried
gt; everything!!!
gt;

=MIN(A1,60)

=IF(A1lt;0,0,A1)Gord Dibben Excel MVPOn Wed, 14 Dec 2005 11:05:21 -0800, Decopk gt;
wrote:

gt;I'm trying to make a worksheet and I need any number over 60 to be equal to
gt;60. Or how can I make any negative number a zero? Please help, I've tried
gt;everything!!!