Results 1 to 6 of 6

Multiple IF statement with CONCATENATE

Threaded View

  1. #1
    Registered User
    Join Date
    04-17-2007
    Posts
    10

    Question Multiple IF statement with CONCATENATE

    I cant use this formula. excel gives an error that my statement is too long, what are my other options?

    =IF(AND(F2="100000000000000",E2="02"),CONCATENATE("63",B2,C2),"",IF(AND(F2="010000000000000",E3="06"),CONCATENATE("63",B3,C3),""))

    this is just 2 statements and i am having an error, i thought if i could make 15 statements? I need to CONCATENATE 7 cells (the example above is just 3 cells) based on certain condition. How can i do it? Anyone please? Thanks in advance.

    Like this:
    >B2=11111111
    >B3=22222222
    >C2=3
    >C3=4
    >F2 is from 000000000000000 ... 000010000000000 to 000000000000001 ("1" is moving from left to right)
    >IF F2=”100000000000000” -> output is “63111111113”
    >IF F2=”010000000000000” -> output is “63222222224”
    > I should do this 15 times
    Last edited by dadm20; 04-18-2007 at 07:37 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