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).

By: Johan

483 thoughts on “Min and Max function wrong results

  1. Apk Tv Fechada

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  2. сравнить машину по характеристики

    What i don’t realize is if truth be told how you’re no longer actually a lot more neatly-appreciated than you may be now. You’re so intelligent. You recognize therefore considerably in the case of this topic, made me for my part imagine it from numerous numerous angles. Its like men and women aren’t involved except it’s one thing to accomplish with Woman gaga! Your personal stuffs great. At all times handle it up!| а

  3. bape hoodie

    I have to show appreciation to this writer just for bailing me out of this particular difficulty. Just after researching through the the net and seeing ideas that were not pleasant, I figured my entire life was done. Living without the answers to the problems you’ve solved all through the write-up is a crucial case, as well as ones which might have badly damaged my entire career if I had not discovered your site. Your good training and kindness in handling every aspect was excellent. I’m not sure what I would’ve done if I hadn’t come across such a solution like this. I can also at this point look forward to my future. Thanks very much for this expert and results-oriented help. I won’t think twice to suggest your web site to any person who should receive guide about this problem.

  4. adobe acrobat x pro serial key crack

    I loved as much as you’ll receive carried out right here. The sketch is attractive, your authored material stylish. nonetheless, you command get got an edginess over that you wish be delivering the following. unwell unquestionably come more formerly again since exactly the same nearly very often inside case you shield this hike.| а

  5. jordan retro

    I intended to write you this tiny observation in order to give thanks once again for all the marvelous tricks you’ve discussed on this website. It’s simply extremely generous with you to present openly all many of us would have distributed for an e-book to make some bucks on their own, specifically now that you could possibly have tried it in case you wanted. The good ideas likewise acted as the good way to be sure that someone else have the identical interest the same as my personal own to learn many more on the subject of this condition. I believe there are several more pleasurable instances ahead for many who check out your website.

Comments are closed.