What is the alternative to the MIN function when you have to recognize a cell is blank?

I have the following formula

=IF(N32>1, IF(MIN(H32:H33, J32:J33)>N32, N32,MIN(H32:H33, J32:J33)), " ")

Which works unless H32:H33 is blank, which occasionally is the case.  I know MIN ignores blank cells but I need someway to recognize the value is zero in H32:H33 when it is blank.
LVL 1
Bill GoldenExecutive Managing MemberAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Shaun VermaakTechnical Specialist IVCommented:
Please try
=IF(OR(ISBLANK(H32),ISBLANK(H33)),"Value is blank",IF(N32>1, IF(MIN(H32:H33, J32:J33)>N32, N32,MIN(H32:H33, J32:J33)), " "))

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bill GoldenExecutive Managing MemberAuthor Commented:
I modified your formula...
=IF(OR(ISBLANK(H32),ISBLANK(H33)),"Value is blank",IF(N32>1, IF(MIN(H32:H33, J32:J33)>N32, N32,MIN(H32:H33, J32:J33)), " "))
so that it would return 0 when H32:H33 is blank as follows:
=IF(OR(ISBLANK(H32),ISBLANK(H33)),0,IF(N32>1, IF(MIN(H32:H33, J32:J33)>N32, N32,MIN(H32:H33, J32:J33)), " "))
However, the cell is returning 0 no matter the contents of H23:H33 or J32:J33
0
Bill GoldenExecutive Managing MemberAuthor Commented:
Eureka, I have it...

=IF(ISBLANK(H32:H33),0,IF(N32>0, IF(MIN(H32:H33, J32:J33)>N32, N32,MIN(H32:H33, J32:J33)), " "))

You put me on the right track. Thanks.
1
Bill GoldenExecutive Managing MemberAuthor Commented:
You put me on the right track. Thanks.
0
Shaun VermaakTechnical Specialist IVCommented:
Anytime :)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.