Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

calc prints false when cell empty in screen view

Hi, hoping someone can shed some light on this, please.

I have a Till reconciliation which alerts staff if the till is up or down. The cell calculates if there is a non-zero result and shows "Up" or "Down" if there is a discrepancy between actual and expected values.

The formula is: =IF(C24<0,"DOWN",IF(C24>0,"UP")). Cell C24 contains the formula =ROUND(C23-C22,2). C22 and C23 both contain values entered in pounds and pence.

There are no divisions or multiplications in any of the cells in this sheet.

When using the sheet it shows an empty cell, which is what I want, but on Print Preview and also when the sheet is printed it shows "False", even if the value is zero.

Is there a way to print a blank cell?

calc prints false when cell empty in screen view

Hi, hoping someone can shed some light on this, please.

I have a Till reconciliation which alerts staff if the till is up or down. The cell calculates if there is a non-zero result and shows "Up" or "Down" if there is a discrepancy between actual and expected values.

The formula is: =IF(C24<0,"DOWN",IF(C24>0,"UP")). Cell C24 contains the formula =ROUND(C23-C22,2). C22 and C23 both contain values entered in pounds and pence.

There are no divisions or multiplications in any of the cells in this sheet.

When using the sheet it shows an empty cell, which is what I want, but on Print Preview and also when the sheet is printed it shows "False", even if the value is zero.

Is there a way to print a blank cell?