Thread: How do I apply formula to entire column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Carim Carim is offline
external usenet poster
  
Posts: 510
Default How do I apply formula to entire column
Hi Stephan,

If I understand correctly, you just need to encapsulate your formula
into an If() function :

= If(yourformula=0,"",yourformula)

HTH
Cheers
Carim

Reply With QuoteReply With Quote