View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sqwilly Sqwilly is offline
external usenet poster
 
Posts: 1
Default How to hide rows and/or columns using a formula in excel

I have created a bid template that calculates a price based on the count that
I give it
Example: 22 item abc $45 $990
12 item cba $12
$144
if the item count is 0, I would like it to hide that row, and when I print
the bid, I would like to have the option to hide the columns for unit price
and total price for all items.