View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ms Cranky Ms Cranky is offline
external usenet poster
 
Posts: 2
Default conditional formulas

I want to apply a condition which displays the result of a formula when a
cell value 0 and if cell value =0 then I want it to display as blank. I
tried =IF(G120,"sum(d12+f12)-g12", "") but whilst this displays a blank if
cell value =0 it displays the formula as written if value is 0.

Can anyone help?