Thread: make a negative number zero
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default 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 With QuoteReply With Quote