add to =if(and(c5>1,d5>1,i5=0),"order","")

[msritchie2]

Using current formula but need to add to it

=if(and(c5>1,d5>1,i5=0),"order","") c is min, d is max, i is quantity on hand

I want to be able to add to it so that if i=0 & c=0, it will show order also.

This is getting over my head and I could sure use some guidance.

A big big thanks in advance.

SR

[yawnzzzz]

=if(or(and(c5>1,d5>1,i5=0),and(c5=0,i5=0)),"order","")

[royUK]

msritchie2

Please use the correct forum, I have moved this to the Functions forum.

[msritchie2]

Thank you, I din't realize I was in the wrong place.

[msritchie2]

Thanks for the suggestion. I'll give it a try.

[sglife]

You can also try this

=IF(AND(OR(C6>1,C6=0),D6>1,I6=0),"order","")