IF question

[frepez]

FreddieP wrote:
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(S2>Z2;Z2;IF(S2>Y2;Y2;X2))

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

I have tried HLOOKUP but I couldn't get it to work.

/Freddie

 

[lozzablake]

assuming XYZ=A,B,C and S is D then in your first statement you have:

S2>Z2 as Z is blank S is greater than a blank and so it returns Z2. If you wanit to ignore blanks you need to use an AND statement so the formula knows to ignore blanks eg:

IF(AND(S2>Z2,Z2<>""),Z2,more ifs here)