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.
|