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...