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

shejmay

New member
Joined
Dec 27, 2013
Messages
1
Reaction score
0
Points
0
=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.
tax.jpg

Perhaps there is a better way to approach this?

Thanks,
Sheila
 

Pecoflyer

Admin Alumnus
Joined
Oct 13, 2011
Messages
1,779
Reaction score
0
Points
36
Location
Brussels Belgium
Excel Version(s)
2010 on Xubuntu - O365
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)),"")
 
Top