1015 - NewCalc, Zero Column Width

NewDeal Hot Tip 1015

NewCalc

NewCalc, Zero Column Width

I was struggling with a problem in my business invoice template.
I had columns quantity (C), price (H), and amount (I).
I multiplied the quantity by the price and placed the result in the amount. =IF(C22*H22, C22*H22, "")
This leaves the cell blank if the result is zero.
Then I needed to add up the amount column, =SUM(I22:I41), for the subtotal cell.
Oops, that gives a #TYPE# error.
So I changed the amount column to =IF(C22*H22, C22*H22, 0).
This took care of the #TYPE# error, but put zeros in the cells where I want blanks.
Then I discovered what seems to be the ultimate solution.

I changed I22:I41 back to =IF(C22*H22, C22*H22, "").
This left I42 with the #TYPE# error.
Then I built a new range in column J, J22:J41.
This range uses =IF(C22*H22, C22*H22, 0).
Then I changed the subtotal cell, I42, to =SUM(J22:J41).
This removes the #TYPE# error and gives a good result there.

Here is the cool part:

I selected the J column,
I selected the Cell menu, chose Cell Width, and made the J column zero (0) pixels wide. You'll never see column J and it won't print.

Return to Index

Last Modified 28 Feb 1999