Ask Your Question
0

calc prints false when cell empty in screen view - SOLVED [closed]

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

MG312 gravatar image

updated 2020-09-26 11:59:56 +0200

Alex Kemp gravatar image

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-29 23:48:02.966511

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

Question Tools

1 follower

Stats

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

Seen: 91 times

Last updated: Feb 12 '18