1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL.MI

  • Remove "False" in google sheets

    From Heather Cott@21:1/5 to All on Fri Jan 7 14:41:54 2022
    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))))))))))))

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Bayram Can@21:1/5 to All on Thu Mar 17 21:28:31 2022
    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ı

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)