Multi nested IF, AND, OR formula

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

Leave a Reply

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