=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
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
