Min and Max function wrong results

I cannot work out what I am doing wrong. I want to return the highest value if any of the two values in two cells is above 155, otherwise return the lowest value as shown in the screenshot with the formula. For lowest values in column A it works, but not if the values beloww 155 is in column B (marked red). What am I doing wrong? Is there a better formula? (Excel 2013).
Thanks!

By: Johan

120 thoughts on “Min and Max function wrong results

  1. ps4 games

    This is very interesting, You’re a very skilled blogger.
    I’ve joined your rss feed and look forward to seeking more of your
    magnificent post. Also, I have shared your website in my social networks!

  2. trivago boca chica

    Thank you, I ave just been searching for info about this topic for ages and yours is the greatest I ave discovered so far. But, what about the conclusion? Are you sure about the source?

  3. concrete

    This is a really good tip especially to those new to the blogosphere. Brief but very accurate info Appreciate your sharing this one. A must read article!

  4. ps4 games

    Having read this I thought it was really enlightening.
    I appreciate you taking the time and energy to put this informative article together.

    I once again find myself spending a lot of time both reading and leaving comments.
    But so what, it was still worth it!

Leave a Reply

Your email address will not be published. Required fields are marked *