Conditional format using IF formula

  • First off thank-you for taking the time to read this post and help me solve my problem.


    I am trying to get an IF formula to look at 7 different cells that can contain either a "O" "X" or "N/A". If the 7 cells all contain either a "O" or "N/A" then place an "O" in the A Column under ONE Voice. I have attached the code and a screenshot of the sheet for better understanding. The U in the formula is a keystroke symbol used by my company that produces the "O".


    Code
    =IF(AND(OR(N9="Ù",N9="N/A"),OR(R9="Ù",R9="N/A"),OR(V9="Ù",V9="N/A"),OR(Z9="Ù",Z9="N/A"),OR(AD9="Ù",AD9="N/A"),OR(AH9="Ù",AH9="N/A"),OR(AL9="Ù",AL9="N/A")),"Ù","")


    [ATTACH=CONFIG]66683[/ATTACH]


    The formula doesn't error but it won't populate the cell either.


    Thanks

  • Re: Conditional format using IF formula


    Hi Lanky,


    you say "7 different cells that can contain either a "O" "X" or "N/A"." - I cannot see any reference to the "X' in your formula.
    If any of the referenced cells contain an "X", the result of the if statement will be "". Could this be why the formula isn't populating with the expected result?

  • Re: Conditional format using IF formula


    Kieran,


    No if there is an "X" in any field I don't want it to populate the conditional format in the active cell. So "" would be the preferred outcome.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!