• 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. N

    IF, AND help

    Sachin, this made it work: =IF(AND(G15<=0,H15<>"Closed"),"Red",IF(AND(G15<5,H15="Not Started"),"Yellow","Green"))
  2. N

    IF, AND help

    Thanks all for your input. Sachin, the only thing I see missing is.... the "yellow" condition is triggered for from 0-5 and not started. tx,Neillat
  3. N

    IF, AND help

    hello, I'm trying to figure out the right logic statement for a project mgmt file, that will give me a "Green" "Yellow or "Red" for a given set of conditions. I have totally confused myself, so I have stopped and seeked help :) Here are the combo possibilities: condition 1 condition 2 result...
  4. N

    Hello .. Introduce yourself

    Hello All! I'm just joining here and have some questions for the pros! Cheers neillat
Back
Top