I have 3 columns of data, all might be blank or only 2 might be blank or one might be blank I need to show which non-blank cell has the lowest value. I started out with this using the data field example below:

IF(AND(A2=””,B2=””,C2=””),””,IF(AND(A2=””,B2=””,C2>””),$C$1,IF(AND(A2=””,C2=””,B2>””),$B$1,IF(AND(B2=””,C2=””,A2>””),$A$1,IF(AND(A2=””,B2<C2),$B$1,IF(AND(B2=””,A2<C2),$A$1,…………………………

I start getting lost with all the if then am I starting this right do I need to check every time one of these is blank or does the first time through eliminate the blanks? When I think I have it and calcualte I get “False”, if I keep going I’ve already had 10 or 12 nested If’s and only a few correct answers and then the “False” answer.

By: Earl