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
|