Conditional format using IF formula

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    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?

    Kieran

    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.

    Re: Conditional format using IF formula


    Thanks for helping I went a different route and used an IF(SUMPRODUCT) formula.

Participate now!

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

Register Yourself Login