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:


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 *