Minimum value with less than

[dmatchers]

I'm trying to figure out this formula: minimum value in the range which is less than zero than to display a result if Need to order parts or Not.

so far this is what i have: {=MIN(IF(AND(04>0,04<0),"OK","Not enough parts"))}.

But i get an error message a value used in the formula is of the wrong data type.

 

[barry houdini]

Hello dmatchers, welcome to MrExcel,

For O4 to be both >0 and <0 it would need to be zero, wouldn't it?

Can you explain what the formula is supposed to do?

 

[dmatchers]

Enter a function that tests whether the minimum value in the range O4:O23 is less than zero. If so, the result suppose to show "Not enough Parts" or if there's enough parts than it suppose to show a result "OK".

Guess I need to find the minimum in column O first?
This is regarding an inventory sheet. Plus I have green arrows (error) that showed up on the previous step before this which will be my next question. I did conditional formatting and that's when it appeared. So maybe you can help me on this after?

Thank you. I'm not a professional with excel?

 

[barry houdini]

OK try this formula

=IF(MIN(O4:O23)<0,"Not enough parts","OK") ​

 

[dmatchers]

Thank you so much! It worked.

Are you able to help me on the other one i stated?