multiple if functions with array

[stinkypete]

i am having problems with the formula breaking down when i change the wind depth to <=100m and 400m. instead of returning the right value, 0 is returned.

thanks in advance

[ChemistB]

The purpose of the formulas is outside my realm of expertese but I can tell you this. This part of the formula

Please Login or Register  to view this content.

goes through the array of E20:E28 and returns the respective value in D20:D28 checking each one to see if it's the minimum. IF the formula result equals D20:D28. If it does not equal D20:D28 (and that must be true for values <=100 m wind depth), then it returns FALSE or 0. As you are looking for the minimum, the array returns the 0 value.

Was that helpful?

[stinkypete]

Thanks ChemistB it was helpfull. Sorry for the formulas being so daunting. I used the evaluate formula tool, turns out that it was a rounding error with excel. For example, at 410m it was looking at 652.999999999999 not 653. I have fixed it with the code in B11 now -

Please Login or Register  to view this content.