Forum Discussion
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%,...
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%)))))
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%)))))
That formula didn't return anything. Here is a sample worksheet.
please see the corrected formula in the attached workbook.
can you please just copy and paste it here so I don't have to download anything?
wrote:please see the corrected formula in the attached workbook.
- in G6 cell put this formula and copy down
=IF(ISNUMBER(SEARCH("VQ",C6)),IF($F$25<40000,D6*22%,IF(AND($F$25>=40000,$F$25<=70000),D6*25%,D6*28%)),IF(ISNUMBER(SEARCH("BS",C6)),IF($F$25<40000,D6*44%,IF(AND($F$25>40000,$F$25<=70000),D6*50%,D6*56%)),""))