Add Condition

  • Thread starter Thread starter Biola
  • Start date Start date
B

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




.
Click to expand...
 
Back
Top