Multiple IF Statements

James.Johnson

hello,

I have this formula that works great: =IF(Status@row = "Complete", 1). I change the "Status" to complete and the "Done" column box is checked.

However, when I change the Status to "Abandoned" or "Reassigned" I also want the "Done" column box checked "Complete."

How do I do multiple IF functions? The "Nesting IF Functions" help page was...well, no help.

Thanks!

L_123

=if(or(Status@row = "Complete",Status@row = "Abandoned", Status@row = "Reassigned"),1,0)

L_123

=if(or(Status@row = "Complete",Status@row = "Abandoned", Status@row = "Reassigned"),1,0)

James.Johnson

perfect! thank you!