excel if and / or ... except

Posted on 2014-08-04
Last Modified: 2014-08-05
Hello Experts ...

here is a smaller scenario of what i have.

cell b1,c1,d1 can contain X or Y.
If any of the cells contain X, then place A in cell A1, unless any of the cells contain Y, in this case place a BLANK in cell A1.

used If or for the first part, which works well, but cant figure out the other part.

Question by:Karl Lalloo
    LVL 47

    Accepted Solution


    pls try

    shorter version



    Author Comment

    by:Karl Lalloo
    Thanks, will give it a try.

    I did use a workaround though that gave me the results i needed .... used conditional formatting to change font to background colour.

    Will let you know.

    Thanks, K

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    When we have a dead host and we lose all connections to the ESXi, and we need to find a way to move all VMs from that dead ESXi host.
    If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
    Viewers will learn how to create a PivotTable and make basic changes to it in Excel 2013.
    Viewers will learn the basics of printing in Excel 2013 and how to adjust some common settings.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now