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

226 thoughts on “Min and Max function wrong results

  1. tinyurl.com

    Oh my goodness! Amazing article dude! Many thanks, However I am experiencing troubles with your RSS.

    I don’t understand the reason why I can’t subscribe to it.
    Is there anybody having similar RSS issues? Anybody who knows the answer can you kindly
    respond? Thanks!!

  2. coach outlet online

    I am writing to make you understand of the amazing encounter our princess had reading your web page. She discovered numerous details, which include how it is like to possess a great helping spirit to make the mediocre ones without difficulty learn about various complicated subject matter. You really surpassed our expectations. Thanks for rendering these important, dependable, informative and also unique tips about that topic to Ethel.

  3. nike air max 90

    I as well as my pals appeared to be reading through the excellent helpful tips from your website and so immediately got an awful feeling I never expressed respect to the site owner for them. The boys were so warmed to study all of them and have in effect quite simply been making the most of these things. Thanks for genuinely very accommodating as well as for deciding upon some remarkable topics millions of individuals are really wanting to be informed on. My very own sincere regret for not expressing gratitude to you earlier.

  4. Love Irrigation

    I will right away snatch your rss as I can not in finding your email subscription link or newsletter service. Do you have any? Please let me recognize in order that I may just subscribe. Thanks.

  5. Best CBD Oil

    You created some respectable factors there. I seemed on the net for the problem and located many people will go along with together with your internet site.

  6. online cvv store

    I was suggested this website by my cousin. I am not sure whether this post is written by him as no one else know such detailed about my difficulty. You are amazing! Thanks!

  7. supreme clothing

    Needed to put you that very little note to finally say thank you again for all the superb advice you have documented in this article. It was simply incredibly open-handed with people like you to make extensively all that a few people would’ve sold for an e book in making some profit for themselves, especially seeing that you could have tried it in case you considered necessary. Those techniques as well served to be the great way to be aware that other people have the identical desire much like my own to realize somewhat more in terms of this condition. I know there are thousands of more enjoyable times ahead for individuals who start reading your website.

  8. Fidel Yetzer

    The wind is blowing my hair softly, and the leaves are gently floating beside you. Looking at the blue sky, sitting on the green grass, so warm and harmonious. I really want to stop this moment and let us be happy together for a lifetime!

Leave a Reply

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