Forum Discussion

Jason Montet's avatar
Jason Montet
Copper Contributor
Apr 08, 2018

Formula won't return blank

Can someone help me figure out how to get this formula to return a blank if the whole thing is false?

 

=IF(ISNUMBER(SEARCH("VQ",C9)),IF($F$25<40000,D9*22%,IF(AND($F$25>=40000,$F$25<=70000),D9*25%,D9*28%)),IF(ISNUMBER(SEARCH("BS",C9)),IF($F$25<40000,D9*44%,IF(AND($F$25>40000,$F$25<=70000),D9*50%,D9*56%))))

Excel Desktop
Formulas & Functions

7 Replies

  • Jamil's avatar
    Jamil
    Bronze Contributor
    Apr 09, 2018
    Here you go

    =IF(ISNUMBER(SEARCH("VQ",C9)),IF($F$25<40000,D9*22%,IF(AND($F$25>=40000,$F$25<=70000),D9*25%,D9*28%)),IF(ISNUMBER(SEARCH("BS",C9)),IF($F$25<40000,D9*44%,IF(AND($F$25>40000,$F$25<=70000),D9*50%,D9*56%))""))
      • Jamil's avatar
        Jamil
        Bronze Contributor
        Apr 09, 2018
        It is difficult to evaluate formula without the actual workbook or its sample.

        it appears that your formula may have flaws in the logical testing. again, not sure if this works for you but you can test this one

        =IF(IF(ISNUMBER(SEARCH("VQ",C9)),IF($F$25<40000,D9*22%,IF(AND($F$25>=40000,$F$25<=70000),D9*25%,D9*28%)),IF(ISNUMBER(SEARCH("BS",C9)),IF($F$25<40000,D9*44%,IF(AND($F$25>40000,$F$25<=70000),D9*50%,D9*56%))))=FALSE,"",IF(ISNUMBER(SEARCH("VQ",C9)),IF($F$25<40000,D9*22%,IF(AND($F$25>=40000,$F$25<=70000),D9*25%,D9*28%)),IF(ISNUMBER(SEARCH("BS",C9)),IF($F$25<40000,D9*44%,IF(AND($F$25>40000,$F$25<=70000),D9*50%,D9*56%)))))

Resources