View Single Post
  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default

slight correction

=IF(SUM(N8:N9)-SUM(N20:N21)=0,"",SUM(N8:N9)-SUM(N20:N21))

--
HTH

Bob Phillips

"Bob Phillips" wrote in message
...
=IF(SUM(N8:N9)-SUM(N20:N21)=0,"",SUM(N8:N9)-SUM(N20:N21))

--
HTH

Bob Phillips

"force530" wrote in message
...
=SUM(N8:N9)-SUM(N20:N21)

If the results from the above formula are 0 or less than 0, how can I

leave
the results blank or at 0?