Calc prints false when cell empty in screen view - SOLVED

[MG312]

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?

[mikekaganski]

Your formula expands to this:

• If C24 is less than zero, then print string “DOWN”
• Else if it is more than zero, then print string “UP”
• Else, as the second IF's “Else” clause is omitted, do the default Else action, which is output the result of comparison C24>0, which is FALSE in this case.

You could use this:

=IF(C24<0;"DOWN";IF(C24>0,"UP";""))

[MG312]

Thanks Mike, you’ve solved my problem!

[librebel]

Hello @MG312,

To mark the above answer as correct, please click on the circular checkmark icon at the left side of the answer, so that it turns green.