Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

"It's like deja vu all over again." -- Yogi Berra

computers / microsoft.public.excel.misc / Re: Remove "False" in google sheets

SubjectAuthor
* Remove "False" in google sheetsHeather Cott
`- Re: Remove "False" in google sheetsBayram Can

1
Remove "False" in google sheets

<ae349ab7-91ae-48fb-baec-101e4586997dn@googlegroups.com>

  copy mid

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

  copy link   Newsgroups: microsoft.public.excel.misc
X-Received: by 2002:ad4:5cc6:: with SMTP id iu6mr701722qvb.71.1641595314671;
Fri, 07 Jan 2022 14:41:54 -0800 (PST)
X-Received: by 2002:a05:6820:3d8:: with SMTP id s24mr831101ooj.69.1641595314408;
Fri, 07 Jan 2022 14:41:54 -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: Fri, 7 Jan 2022 14:41:54 -0800 (PST)
Injection-Info: google-groups.googlegroups.com; posting-host=2601:649:101:870:a13e:ee55:a379:d693;
posting-account=S0bD7goAAADxhxbpzmJBx3Wy7UFG1dhh
NNTP-Posting-Host: 2601:649:101:870:a13e:ee55:a379:d693
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <ae349ab7-91ae-48fb-baec-101e4586997dn@googlegroups.com>
Subject: Remove "False" in google sheets
From: hheather...@gmail.com (Heather Cott)
Injection-Date: Fri, 07 Jan 2022 22:41:54 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Lines: 21
 by: Heather Cott - Fri, 7 Jan 2022 22:41 UTC

Hello,
I know there are a lot of these questions but my formulas seem to be a bit different and I am not sure where to add the "false" part of it.

I have drop-down menus where I chose something and it populates that services company name and phone number so on the cells where I don't have anything picked on the drop-down, it just says "False" and I need that gone. I am completely out of ideas.

Thank you for your help and expertise!

Here is my condition:
=IF(B42="Cable",QUERY(CompanyInfo,"SELECT B WHERE A='Cable'"),IF(B42="Septic",QUERY(CompanyInfo,"SELECT B WHERE A='Septic'"),IF(B42="WIFI",QUERY(CompanyInfo,"SELECT B WHERE A='WIFI'"),IF(B42="HVAC",QUERY(CompanyInfo,"SELECT B WHERE A='HVAC'"),IF(B42="Pool Service",QUERY(CompanyInfo,"SELECT B WHERE A='Pool Service'"),IF(B42="Propane",QUERY(CompanyInfo,"SELECT B WHERE A='Propane'"),IF(B42="Pump/Well",QUERY(CompanyInfo,"SELECT B WHERE A='Pump/Well'"),IF(B42="Trash",QUERY(CompanyInfo,"SELECT B WHERE A='Trash'"),IF(B42="Recology",QUERY(CompanyInfo,"SELECT B WHERE A='Recology'"),IF(A8="purple",5,IF(A8="yellow",6,IF(A8="green",7))))))))))))

Re: Remove "False" in google sheets

<a7b8f80e-24a0-4591-be60-cfe6c23f7058n@googlegroups.com>

  copy mid

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

  copy link   Newsgroups: microsoft.public.excel.misc
X-Received: by 2002:ac8:5f49:0:b0:2e1:b989:7aab with SMTP id y9-20020ac85f49000000b002e1b9897aabmr6247803qta.465.1647577711442;
Thu, 17 Mar 2022 21:28:31 -0700 (PDT)
X-Received: by 2002:a54:400d:0:b0:2ec:ba55:6be9 with SMTP id
x13-20020a54400d000000b002ecba556be9mr7255330oie.38.1647577711221; Thu, 17
Mar 2022 21:28:31 -0700 (PDT)
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: Thu, 17 Mar 2022 21:28:31 -0700 (PDT)
In-Reply-To: <ae349ab7-91ae-48fb-baec-101e4586997dn@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=5.176.77.66; posting-account=1hnTZAkAAAAxPdLinrhxmUv2VvJlA-zs
NNTP-Posting-Host: 5.176.77.66
References: <ae349ab7-91ae-48fb-baec-101e4586997dn@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <a7b8f80e-24a0-4591-be60-cfe6c23f7058n@googlegroups.com>
Subject: Re: Remove "False" in google sheets
From: bayramca...@gmail.com (Bayram Can)
Injection-Date: Fri, 18 Mar 2022 04:28:31 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Lines: 25
 by: Bayram Can - Fri, 18 Mar 2022 04:28 UTC

8 Ocak 2022 Cumartesi tarihinde saat 00:41:56 UTC+2 itibarıyla Heather Cott şunları yazdı:
> Hello,
> I know there are a lot of these questions but my formulas seem to be a bit different and I am not sure where to add the "false" part of it.
>
> I have drop-down menus where I chose something and it populates that services company name and phone number so on the cells where I don't have anything picked on the drop-down, it just says "False" and I need that gone. I am completely out of ideas.
>
> Thank you for your help and expertise!
>
> Here is my condition:
> =IF(B42="Cable",QUERY(CompanyInfo,"SELECT B WHERE A='Cable'"),IF(B42="Septic",QUERY(CompanyInfo,"SELECT B WHERE A='Septic'"),IF(B42="WIFI",QUERY(CompanyInfo,"SELECT B WHERE A='WIFI'"),IF(B42="HVAC",QUERY(CompanyInfo,"SELECT B WHERE A='HVAC'"),IF(B42="Pool Service",QUERY(CompanyInfo,"SELECT B WHERE A='Pool Service'"),IF(B42="Propane",QUERY(CompanyInfo,"SELECT B WHERE A='Propane'"),IF(B42="Pump/Well",QUERY(CompanyInfo,"SELECT B WHERE A='Pump/Well'"),IF(B42="Trash",QUERY(CompanyInfo,"SELECT B WHERE A='Trash'"),IF(B42="Recology",QUERY(CompanyInfo,"SELECT B WHERE A='Recology'"),IF(A8="purple",5,IF(A8="yellow",6,IF(A8="green",7))))))))))))

Adana masaj https://masaj.sevcez.com/Masaj/Adana-Masaj ilanları

computers / microsoft.public.excel.misc / Re: Remove "False" in google sheets

1
server_pubkey.txt

rocksolid light 0.9.81
clearnet tor