Thread: Calculating a value but omitting cells with empty data
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions,microsoft.public.excel
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default Calculating a value but omitting cells with empty data
"Andrew Chalk" wrote...
It is actually a cell calculation. An example is:

=(G13-G12)/G12

If G12 is not zero I want the above calculation to be done.

If it is zero I want to not do the above calculation, but the value zero to
be used instead
....

=IF(COUNT(1/G12),G13/G12-1,0)
Reply With QuoteReply With Quote