How to deal with blank cells

[gary153]

I have a formula that looks for the minimum from 6 cells and then applies some other functions. Problem is, sometimes not all cells contain data - eg sometimes they are blank. How can I adjust the formula to look for the minimum of cells with numbers and ignore blank cells?

The formula I need to change is: =MIN(IF(AE60:AE65=0,"",AE60:AE65))*0.7+(0.5)

Or, would I be better to adjust the formula in column AE which at present is: =IF(ISERROR(SUM(AC60-AD60)),"",(SUM(AC60-AD60))) sometimes AC & AD are blank so this formula then returns blanks

[gary153]

Sorry, I meant to post some data example: formula to change in red

AE
0.28 20.80 0.09 20.61 -0.21 20.61 20.61 9% 0.05 0.70
0.91 20.80 0.12 20.01 -0.12
0.86 20.80 0.09 20.03 -0.09
0.63 20.80 -0.07 20.10 -0.15
#N/A
#N/A

[MarvinP]

Hi Gary,

I think the blank cells are ignored and not counted as zero. Look at:

https://support.office.com/en-us/art...F-96F202DCC152
and the section that reads,
If an argument is an array or reference, only numbers in that array or reference are used. Empty cells, logical values, or text in the array or reference are ignored.

The section after that says if you have NO numbers in your 6 cells then it returns a zero. Is this what is happening?