# MIN Function Returning Zero

• I am using a MIN Function, but it continues to return "0" for all rows due to blank cells.

These are the formulas I have tried so far:

=MIN(BHS2:BWT2)

=MIN(IF(ISNUMBER(BHS2:BWT2),IF(BHS2:BWT2>0,BHS2:BWT2))) Ctrl+Shift+Enter

=MIN(IF(BSH2:BWT2 <>0,BHS2:BWT2)) + Ctrl + Shift + Enter

All of these formula continue to return a "0".

The numbers in the data set run from 1-17 with no 0, but many blank cells.

• Try this Array* formula:

=MIN(IF(BHS2:BWT2<>"",BHS2:BWT2))

[arf]*[/arf]

Where there is a will there are many ways. Finding one that works for you is the challenge!

• Try this Array* formula:

=MIN(IF(BHS2:BWT2<>"",BHS2:BWT2))

[arf]*[/arf]

I tried this and it still only returns "0". Yes, I did Ctrl+Shift+Enter.

Any other ideas are more than welcome!!

• Nevermind I figured out my problem the formula in BHS:BWT was returning a "1","2",... Once I changed these to 1,2,3 your formula and all other formulas I was trying worked. Stupid mistake between number and string.

Thanks for you help though!

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!