Thread: calculation
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo
 
Posts: n/a
Default calculation

if(or(a2=0,a2="",0,...)

.... = your formula

hth
regards from Brazil
Marcelo

"M.Ummer Malik" escreveu:

when i apply a ifor formula and if there is a formula in source cell the
result is displaying 0 zero i whish to keep is blank in result cell if result
is 0' if all source cells are empty the result is comming as blank.(if or
formula false)