Hi I have in a row 3 different values that I want to compare with a specific
value on the same row. It looks like below

A B C D
10 20 30 22

If D is higher than B I want it to return B if is lower I want it to return
A. So far so good, this I can do but if it looks like below and b & c are
empty, I cant get it to return, A it just returna a blank.

A B C D
10 22

This is the formula I used.

=IF(S2Z2;Z2;IF(S2Y2;Y2;X2))

I'ts kind of hard to explain what I mean, I hope someone understands my
question :)

/Freddie