Results 1 to 4 of 4

Thread: Help with a formula

  1. #1

    Help with a formula



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

    In Excel 2007 is there a formula that can do the following:
    In cells A1 to A7 you have 1-7 but I want to return a single value to A8, eg

    If A1 to A7 equals 1 return 1 to A8, but if A1 to A7 equals 2 return 2 to A8, but if A1 to A7 equals 3 return 3 to A8, but if A1 to A7 equals 4 return 4 to A8 and so on.

    Thanks

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    So each of the cells in the range A1 to A7 contain the same number?

    What if they don't?


  3. #3
    Hi,

    I am trying to create/add a formula that transforms a cell containing a name into email address. I wanted something smilar to Outlook when you are clicking on CTRL+K and from name it becomes email address. Let me know if you know how or if you need more details..

    I reallly appreciate it!!!

    Thank you,
    Maria

  4. #4
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by mdmaria View Post
    Hi,

    I am trying to create/add a formula that transforms a cell containing a name into email address. I wanted something smilar to Outlook when you are clicking on CTRL+K and from name it becomes email address. Let me know if you know how or if you need more details..

    I reallly appreciate it!!!

    Thank you,
    Maria
    Hello Maria
    I think you have posted your question to an (unrelated) existing thread instead of the correct procedure, which is to start a new one.

Posting Permissions

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