View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arvi Laanemets
 
Posts: n/a
Default If/Then Forumla to create blank cell???

Hi


"MartinW" wrote in message
...
Some might say sneaky!! Some might even say cheating!!
Me, I say BRILLIANT!!


But, when p.e. you calculate average from this range, such 'hidden' 0's are
taken fully into account (the same for unchecking zero values).


Arvi Laanemets