Results 1 to 3 of 3

Thread: Formulas

  1. #1

    Formulas



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

    Hi,


    Is there a way of putting an if statement in to say that if column C has an answer of ALL then put that answer in column A if column C says anything other than ALL then put it in column B?


    Many Thanks for your answers.

  2. #2
    Acolyte Canapone's Avatar
    Join Date
    Oct 2011
    Location
    Italy
    Posts
    97
    Articles
    0
    Hi, in A2: =IF(C2="ALL",C2,"") in B2: =IF(C2<>"ALL",C2,"") . Hope it helps

  3. #3
    Wooooo hooooooo many thanks for your super quick response!!!!!!!!

Posting Permissions

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