Results 1 to 2 of 2

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    =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.
    Click image for larger version. 

Name:	tax.jpg 
Views:	20 
Size:	100.7 KB 
ID:	1927

    Perhaps there is a better way to approach this?

    Thanks,
    Sheila

  2. #2
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,462
    Articles
    0
    Excel Version
    2010 on Xubuntu
    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)),"")

Tags for this Thread

Posting Permissions

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