Multiple true conditions in an If statement formula

Question

Hey all, I'm trying to set up a checkbox formula to only be checked "if" about 10 different fields are all also checked off. I was able to make the function work with 2 variables:
If([Personal Data Form],[Photo ID]=true, true) //checks "Paperwork Complete" if fields are also checked

...but I can't seem to add more than that. From what I've read, the case function would check "paperwork complete" if any of the listed fields are checked. How would I expand the if statement to an if/and so that "paperwork complete" is only checked if all the listed fields are also checked?

Thank you!

------------------------------
Dana Krauss
------------------------------

markshnier__you · Answer

This will work.&nbsp; if you are checking other checkbox fields, then just "and" them together like this.&nbsp; Do not need to have an IF.[Personal Data Form]and[Personal Data Form]and[Photo ID]and [my next field]and[my next next field]------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

danakrauss · Answer

Mark, thank you so much! This worked. Perhaps better fit for a different thread, but is there a way to add 2 identical text - multiple choice fields to the and statements? We are looking for the functionality noted in the comments below:

[Personal Data Form]
and
[Photo ID]
and
// if drug screen is selected as "Completed"
and
// if background check is selected as "Completed"

------------------------------
Dana Krauss
------------------------------

markshnier__you · Answer

sure[Personal Data Form]and[Photo ID]and[drug screen] =&nbsp; "Completed"and[background check] =&nbsp; "Completed"------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Forum Discussion

Multiple true conditions in an If statement formula