Elance Exams Answers PDF file

-- PDF FILE --
Download PDF file of elance Zoho Creator Exam Answers
elance-zoho-creator-exam.pdf

What is the correct formula to reflect the logic "If cell A1="Pass" and cell B1="Pass" then cell C1 should equal "Pass", otherwise C1 should equal 'Fail' "?

=IF(A1="Pass" AND B1="Pass"),"Pass","Fail")
=IF(AND(A1="Pass",B1="Pass"),"Pass","Fail")
=(A1="Pass" and B1="Pass", then "Pass", else "Fail")
=IF(OR(A1="Pass",B1="Pass"),"Pass","Fail")
Top
  • Follows us our servcies
  • Facebook icon
  • Linkedin icon
  • twitter icon
  • rss icon
  • social icon