novaBBS - microsoft.public.excel.misc - Remove 'false" cell is empty

Remove 'false" cell is empty

<ffca2c04-8762-4a1f-be75-fda5801ea022n@googlegroups.com>

https://www.novabbs.com/computers/article-flat.php?id=246&group=microsoft.public.excel.misc#246

copy link Newsgroups: microsoft.public.excel.misc

X-Received: by 2002:a05:622a:11ca:: with SMTP id n10mr4080664qtk.567.1644113190829;
Sat, 05 Feb 2022 18:06:30 -0800 (PST)
X-Received: by 2002:a05:6870:b287:: with SMTP id c7mr1577293oao.273.1644113190622;
Sat, 05 Feb 2022 18:06:30 -0800 (PST)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: microsoft.public.excel.misc
Date: Sat, 5 Feb 2022 18:06:30 -0800 (PST)
Injection-Info: google-groups.googlegroups.com; posting-host=72.203.17.174; posting-account=MVs-tAoAAADjFWF7hijirOzRq3zi_pHJ
NNTP-Posting-Host: 72.203.17.174
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <ffca2c04-8762-4a1f-be75-fda5801ea022n@googlegroups.com>
Subject: Remove 'false" cell is empty
From: hime...@gmail.com (Alex Hime)
Injection-Date: Sun, 06 Feb 2022 02:06:30 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Lines: 8

by: Alex Hime - Sun, 6 Feb 2022 02:06 UTC

I have 2 cells and in one I will have a number (1,2,3...) and I want the 2nd cell to say "Term". To show how many Terminations are that day. I was able to show Term when a number is entered, but when it is empty it says "false". How do I hide the false if there is no number without adding 0 or changing text color?

This is the formula I am using
=if(OR (G5=1,G5=2,G5=3,G5=4,G5=5,G5=6,G5=7,G5=8,G5=9), "Term")

Re: Remove 'false" cell is empty

<sto1gr$i9f$1@dont-email.me>

copy mid

https://www.novabbs.com/computers/article-flat.php?id=247&group=microsoft.public.excel.misc#247

copy link Newsgroups: microsoft.public.excel.misc

Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: claus_bu...@t-online.de (Claus Busch)
Newsgroups: microsoft.public.excel.misc
Subject: Re: Remove 'false" cell is empty
Date: Sun, 6 Feb 2022 09:39:55 +0100
Organization: A noiseless patient Spider
Lines: 17
Message-ID: <sto1gr$i9f$1@dont-email.me>
References: <ffca2c04-8762-4a1f-be75-fda5801ea022n@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
Injection-Date: Sun, 6 Feb 2022 08:39:55 -0000 (UTC)
Injection-Info: reader02.eternal-september.org; posting-host="bd369c4517a354ff12722955ffde9ca2";
logging-data="18735"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/AL9c5tZafsv964TkXAUl60Mo1fR4sTtM="
User-Agent: 40tude_Dialog/2.0.15.1de (e154d6fe.490.54)
Cancel-Lock: sha1:y7PKbj8LTkMMqGjmxTk3c2iwMC4=

by: Claus Busch - Sun, 6 Feb 2022 08:39 UTC

Hi Alex,

Am Sat, 5 Feb 2022 18:06:30 -0800 (PST) schrieb Alex Hime:

> I have 2 cells and in one I will have a number (1,2,3...) and I want the 2nd cell to say "Term". To show how many Terminations are that day. I was able to show Term when a number is entered, but when it is empty it says "false". How do I hide the false if there is no number without adding 0 or changing text color?
>
> This is the formula I am using
> =if(OR (G5=1,G5=2,G5=3,G5=4,G5=5,G5=6,G5=7,G5=8,G5=9), "Term")

try:
=IF(AND(G5>0,G5<=9,MOD(G5,1)=0),"Term","")

Regards
Claus B.
--
Windows10
Microsoft 365 for business

Trespassers will be shot. Survivors will be prosecuted.

computers / microsoft.public.excel.misc / Remove 'false" cell is empty

computers / microsoft.public.excel.misc / Remove 'false" cell is empty

Subject	Author
Remove 'false" cell is empty	Alex Hime
Re: Remove 'false" cell is empty	Claus Busch