Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Remove "False" in google sheets

17 views
Skip to first unread message

Heather Cott

unread,
Jan 7, 2022, 5:41:56 PM1/7/22
to
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))))))))))))

Bayram Can

unread,
Mar 18, 2022, 12:28:32 AM3/18/22
to
8 Ocak 2022 Cumartesi tarihinde saat 00:41:56 UTC+2 itibarıyla Heather Cott şunları yazdı:
Adana masaj https://masaj.sevcez.com/Masaj/Adana-Masaj ilanları
0 new messages