View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andrea Andrea is offline
external usenet poster
 
Posts: 112
Default display negative numbers as zero

can i display a negative number as a zero?

thus if my formula reads: if(a4a5, a2, a4-a2) but a4-a2 cannot equal a
negative number? lowest it can be is zero. this formula appears on multiple
workbooks, thus it cannot just be if(a4a5, a2,0).

thnaks.

--
Andrea