Thread: How do I hide the #DIV0! statement in a cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
  
Posts: 3,942
Default How do I hide the #DIV0! statement in a cell?
hi
turn you formula into an if statement.
lets say your formula is in c2 and the dependents are in A2 and B2 with B2 = 0

=if(B2=0, "",A2/B2) or =if(B2=0,0,A2?B2)

Regards
FSt1

"JSN" wrote:

Trying to make a spreadsheet more presentable by removing the #DIV0!
statements which result in formulas with 0 or no values.
Reply With QuoteReply With Quote