+ Reply to Thread
Results 1 to 2 of 2

switch statement

  1. #1
    Forum Contributor
    Join Date
    05-04-2005
    Posts
    136

    switch statement

    is there a switch statement that i can use in a cell as a formula?

    i have a value in col a.
    in col e i want that if the value in a is 1, it should return the value in col B, if it's 2, return col C if it's 3, return col D.

    I know that i can do this with a nested if statement but i prefer switch -

    if someone can please tell me how to do this i would really appreciate it.

    Thank you.

  2. #2
    JE McGimpsey
    Guest

    Re: switch statement

    One way:

    E1: =CHOOSE(A1,B1,C1,D1)

    In article <tkaplan.1s4gqe_1121281519.2769@excelforum-nospam.com>,
    tkaplan <tkaplan.1s4gqe_1121281519.2769@excelforum-nospam.com> wrote:

    > is there a switch statement that i can use in a cell as a formula?
    >
    > i have a value in col a.
    > in col e i want that if the value in a is 1, it should return the value
    > in col B, if it's 2, return col C if it's 3, return col D.
    >
    > I know that i can do this with a nested if statement but i prefer
    > switch -
    >
    > if someone can please tell me how to do this i would really appreciate
    > it.
    >
    > Thank you.


+ Reply to Thread

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