Thread: Simple One
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Simple One

Thank you for the correction, I transposed the request.

David Biddulph wrote:

The OP asked for the zero not to show if the TOTAL is zero, not if the
PRODUCT is zero, so you could change that to
=if(A2+B2, A2+B2,"")