Ask Your Question
0

calc prints false when cell empty in screen view - SOLVED

asked 2018-02-12 12:23:17 +0200

MG312 gravatar image

updated 2018-02-12 15:02:40 +0200

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
2

answered 2018-02-12 12:30:47 +0200

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";""))

edit flag offensive delete link more

Comments

Thanks Mike, you've solved my problem!

MG312 gravatar imageMG312 ( 2018-02-12 15:01:40 +0200 )edit
1

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.

librebel gravatar imagelibrebel ( 2018-02-12 16:12:17 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-02-12 12:23:17 +0200

Seen: 31 times

Last updated: Feb 12 '18