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

Leave a Reply

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