Thread: hiding blank cells when no results
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default hiding blank cells when no results
"andyell" wrote:
.. i have tried to hide them using =if(a3=" "," ",rest of formula

Think you were quite close in your attempt, just try it as:
=if(A3="","",rest of formula)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With QuoteReply With Quote