Thread: show empty cell when result is 0
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default show empty cell when result is 0
Try

=if(myformula0,myyformula,"")

Mike

"willemeulen" wrote:

I want cells to show nothing (empty) when the result is zero. It only should
display result when there are actual values (more than zero)
Reply With QuoteReply With Quote