Formula with conditions

  • Thread starter Thread starter Dewayne
  • Start date Start date
D

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
 
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.
 
Many thanks for the help!
No I didn't realize mutual exclusivity. Any way around
that?
 
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.
 
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




.
Click to expand...
 
Back
Top