View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Loretta Loretta is offline
external usenet poster
 
Posts: 13
Default If function with two results required

I'm using Excel 2003, have a workbook with multiple linked tabs and one page
(printout tab), I want to hide rows with no data automatically (not manually).

Currently using this function: =IF('Bid Form'!B16=0,"",'Bid Form'!$A16 &"A")
Can I substitute the "" with some command to make it hide the entire row
(when B16=0)??
--
Thanks for your help!
Loretta