• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. B

    Nested IF statements for 3 conditions and multiple outcomes? or COUNTA?

    Thank you!
  2. B

    Nested IF statements for 3 conditions and multiple outcomes? or COUNTA?

    Thank you SirJB7, Muneer & Ajit! I can do without the commas in the result and searching the site for nested if statements didn't yield quite what I was looking for. Both methods work well with the exception of when there is a text value in column "B" and "no" in columns A & C. The result...
  3. B

    Nested IF statements for 3 conditions and multiple outcomes? or COUNTA?

    Hi! I have 3 conditions (A,B,C) with either no or text as input. I'd like all possible combinations in the results column. |____A____|___ B____|____C____|__getting__|___wanted__| |____NO___|____NO___|____NO___|____n/a____|____n/a____| works! |____3Z___|____NO___|____NO___|___A @ 3Z__|___A...
Back
Top