Results 1 to 2 of 2

Thread: Would like to have an "or" in an if, then statement

  1. #1

    Would like to have an "or" in an if, then statement



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

    I would like to have the formula below to allow for $B$32 or $C$32. Is this possible? Thank you in advance.


    =IF($B$32=2,VLOOKUP($B$29+$C$29,'2 - MFJ'!$A$1:$C$7,2,TRUE)+VLOOKUP($B$29+$C$29,'2 - MFJ'!$A$1:$C$7,3,TRUE)*($B$29+$C$29-VLOOKUP($B$29+$C$29,'2 - MFJ'!$A$1:$C$7,1,"TRUE")),"")

  2. #2
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,359
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Perhaps =IF(OR($B$32=2,$C$32=2),VLOOKUP.....

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
  •