Link to home
Avatar of Bill Golden
Bill GoldenFlag for United States of America

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of Shaun Vermaak
Shaun Vermaak
Flag of Australia image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Bill Golden

ASKER

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
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.
You put me on the right track. Thanks.
Anytime :)