Thread: format a cell to read zero for any negative value
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default format a cell to read zero for any negative value
Another way: =MAX(0,SUM(A1:A10))
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--


Reply With QuoteReply With Quote