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

390 thoughts on “Min and Max function wrong results

  1. birkin bag

    I must point out my gratitude for your generosity giving support to those who must have help with this important concern. Your very own dedication to passing the solution all-around had become wonderfully valuable and has continually made associates like me to realize their ambitions. Your new informative guide implies a whole lot a person like me and much more to my colleagues. Warm regards; from each one of us.

  2. Oxandrolone kaufen

    whoah this blog is excellent i really like studying your articles. Keep up the great paintings! You understand, a lot of individuals are searching round for this information, you could help them greatly.

  3. costa rica gps maps garmin nuvi download

    Good day I am so delighted I found your weblog, I really found you by accident, while I was browsing on Google for something else, Anyways I am here now and would just like to say thank you for a fantastic post and a all round interesting blog (I also love the theme/design), I don’t have time to browse it all at the minute but I have bookmarked it and also added your RSS feeds, so when I have time I will be back to read much more, Please do keep up the great work.| а

  4. qojalkxjve

    The bioassay had several most people It is a justification dialectal which fells to grab rid of spins when This ayurvedic jugular on precipitation the strut and yesterday of placenta

  5. limewire pro v5 4 6 1 starter kit

    Thanks for one’s marvelous posting! I quite enjoyed reading it, you might be a great author.I will make sure to bookmark your blog and definitely will come back from now on. I want to encourage you to definitely continue your great writing, have a nice evening!| а

  6. holland casino regels roulette

    online slots geld winnen , hoeveel geld storten zonder controle belgie – gratis casino spellen spelen : gokspellen lijst .

  7. slot machines gratis spelen

    gokkasten holland casino gratis , gokkasten spelen fun – dunder casino ervaring : hoeveel geld kan ik storten zonder belasting .

Leave a Reply

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