Thread: How do I omit a blank cell from a calculation??
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
  
Posts: 1,388
Default How do I omit a blank cell from a calculation??
Hi,
If your maybe blank cell is (for example) A10, then try an IF around your
formula, something like:
=IF(A10="","x is blank",YourFormula)
Regards - Dave.
Reply With QuoteReply With Quote