# Thread: Do not want "False" to display with this formula - ideas?

1. ## Do not want "False" to display with this formula - ideas?

=IF(\$B\$28=1,VLOOKUP(\$B\$25,'1 - Single'!\$A\$1:\$C\$7,2,TRUE)+VLOOKUP(\$B\$25,'1 - Single'!\$A\$1:\$C\$7,3,TRUE)*(\$B\$25-VLOOKUP(\$B\$25,'1 - Single'!\$A\$1:\$C\$7,1,TRUE)))

Basically I am building an excel spreadsheet that allows users to chose a tax status (1 - Single, 2 - MFJ, 3 - MFS, of 4 - Head of Household) and input an income. The tax amount is then generated. I want the cell to be blank if the tax status does not apply. Here is a screenshot of the page. Perhaps there is a better way to approach this?

Thanks,
Sheila  Reply With Quote

2. Your IF formula does not contain a FALSE argument, so, try =IF(\$B\$28=1,VLOOKUP(\$B\$25,'1 - Single'!\$A\$1:\$C\$7,2,TRUE)+VLOOKUP(\$B\$25,'1 - Single'!\$A\$1:\$C\$7,3,TRUE)*(\$B\$25-VLOOKUP(\$B\$25,'1 - Single'!\$A\$1:\$C\$7,1,TRUE)),"")  Reply With Quote

#### Tags for this Thread

formulas #### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•