"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