cnq77f

Jan 06 2009

Solved: Need help with IF THEN formula

Filed under: xn--cnq77f.com

  • I would like to create a formula for this equation:

    If B1 is marked with an "x", then insert the text from B2.

    Another addition to my problem is that I would like this formula on a separate worksheet than the one that the x and text is on.

    Thanks for your help!! :nut:


  • I would like to create a formula for this equation:

    If B1 is marked with an "x", then insert the text from B2.

    Another addition to my problem is that I would like this formula on a separate worksheet than the one that the x and text is on.

    Thanks for your help!! :nut:

    =IF(SheetName!B1="X",SheetName!B2,"")

    Substitute SheetName with your sheet name. If your sheet name consist of two or more words, enclose in a single quote.

    =IF('Sheet Name'!B1="X",'Sheet Name'!B2,"")


  • Thank you maxflia10! It worked!! The thing I had wrong in the formula was the last quotation marks. Why do you need those if you have 'SheetName'!B2 there?







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about Solved: Need help with IF THEN formula , Please add it free.

    edit