Hello
I need a nested IF formula which I can't seem to figure out.
Imagine columns A&B with nrs in them, in some cells B has a higher value, in others a lower one.

I need an IF formula to pick the higher or lower nr based on the difference between them - e.g. if the difference is higher than 50, use the lower number [I've made MIN and MAX columns to base the IF formula on them], if not use the higher nr.

The problem comes from the nr. difference which can be either positive or negative and I can't figure out how to make the IF formula properly.

Thank you