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%,...
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%)),""))