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%,...
Excel Desktop
Formulas & Functions
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%))""))
Jason Montet's avatar
Jason Montet
Copper Contributor
Apr 09, 2018

Thanks for the response but that didn't work

  • 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