Thread: if the # is a negative #, then show 0
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anna Anna is offline
external usenet poster
  
Posts: 132
Default if the # is a negative #, then show 0
assume that your value at cell A1,
=IF(A1<0,0,A1)

" wrote:

I cant seem to figure out how to make a formula that when it performs its
calculation and the answer is a negative #, i want it to just show "0".
Is it a IF command?

thanks

Reply With QuoteReply With Quote