View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Frances C[_2_] Frances C[_2_] is offline
external usenet poster
 
Posts: 31
Default Another formula problem

I am using this formula =IF(COUNT(H16,N16)=2,H16*N16*IF(R160,R16,1),"")
and works fine, It does not shows in the cell if I have not enter a number
in H16.

But If I enter zero in H16 the formula does not calculates. Can you help me
with that.