Add Condition

[Biola]

I need to add the following conditon to the formula listed
below:
IF(H10=0,"")

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

The additional condition should be evaluated first.

I can't seem to come up with the correct combination.
Thank you for any help received
Dewayne

 

[JulieD]

Hi

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

you seem to be missing a "false" statement at the end so i put the phrase
"K10=0" in otherwise you'll just get the word False

hope this helps
Cheers
JulieD

 

[Biola]

Received the following on the reply to my post. Please
try again.
Thank you
Dewayne

 

[Biola]

Thanks for the help

-----Original Message-----
Hi

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

you seem to be missing a "false" statement at the end so i put the phrase
"K10=0" in otherwise you'll just get the word False

hope this helps
Cheers
JulieD




.

 

[JulieD]

glad to assist

Thanks for the help