Formula with conditions

[Dewayne]

I need help with the following formula which goes in L10

=IF((I10>0)*AND(J10=0),"On Hold")+IF(I10+J10+K10=0,"Open")
+IF(K10>0,"Closed")

I can't seem to get the right parameters to make it work.

Thanks for any suggestions

 

[Vasant Nanavati]

Try:

=IF(AND(I10>0,J10=0),"On Hold",IF(I10+J10+K10=0,"Open",IF(K10>0,"Closed")))

You do realize that your conditions are not mutually exclusive, and will be
evaluated left to right. IOW, if K10>0, the formula will not return "Closed"
if the first condition is met.

 

[Dewayne]

Many thanks for the help!
No I didn't realize mutual exclusivity. Any way around
that?

 

[Vasant Nanavati]

Yes, you have to decide which condition governs if two or more of them are
met, and place them in order of priority from left to right.

 

[Dewayne]

Thank you very much!
Dewayne

-----Original Message-----
Yes, you have to decide which condition governs if two or more of them are
met, and place them in order of priority from left to right.

--

Vasant




.