Have your number in a1 and this formula i b1:

=if(a1>60;60;if(a1<0;0;a1)

You might need to use "," instead of the ";". ";" 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(formula<0,0,formula) or = MAX(0,formula)

and

=IF(formula>60,60,formula) or =MIN(60,formula)

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

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

=MIN(A1,60)

=IF(A1<0,0,A1)

Gord Dibben Excel MVP