Thread: Formula problem
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 Formula problem

currently I am using this formula =IF(H330,(H33*N33)-R33,"") I works good,
but if I enter H33=0 and N33=0% R33=0 I want the result to be 0, and also
keep the formula showing only if I have number on H33.

How can I solve this problem