Results 1 to 8 of 8

IF formula with 8 conditions-or better formula

Threaded View

koklok IF formula with 8... 02-17-2009, 10:39 AM
NBVC Re: IF formula with 8... 02-17-2009, 10:51 AM
DonkeyOte Re: IF formula with 8... 02-17-2009, 10:53 AM
koklok Re: IF formula with 8... 02-17-2009, 11:48 AM
DonkeyOte Re: IF formula with 8... 02-17-2009, 11:53 AM
NBVC Re: IF formula with 8... 02-17-2009, 11:57 AM
DonkeyOte Re: IF formula with 8... 02-17-2009, 12:04 PM
koklok Re: IF formula with 8... 02-17-2009, 04:25 PM
  1. #1
    Registered User
    Join Date
    10-08-2008
    Location
    Hallandale
    Posts
    44

    IF formula with 8 conditions-or better formula

    I need one formula that will do all this in column G:
    1. IF "VI" in H column return answer in colum G is "MIX"
    2. IF "MC" in H column return answer in colum G is "MIX"
    3. IF "BL" in H column return answer in colum G is "MIX"
    4. IF "DI" in H column return answer in colum G is "Discover"
    5. IF "AX" in H column return answer in colum G is "AMEX"
    6. If column H is empty look into column I and if "PFEE" answer in column G is"FEE"
    7. If column H is empty look into column I and if "IA" answer in column G is"FEE"
    8. If column H is empty look into column I and if "CB" answer in column G is"CHBK"


    I tried using lookup formula but it's not working for some reason
    Any idea how to solve this

    Thanks
    Last edited by koklok; 02-17-2009 at 11:49 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1