Help with AND function

kpierson109

I am trying to have this formula populate a name only if the Component Type is "Teacher Guidance" and the Resource/Object type is blank. I have an incorrect argument set and am not sure how to use AND here or if that is the function I need to use.

=IF(AND([Resource/Object Type]@row = 0, [Component Type]@row = "Teacher Guidance", LOWER(Curriculum@row + ".g" + [Grade/Level]@row + ".m" + Module@row + IF([Concept/Topic/Arc]@row <> "", "." + [Concept/Topic/Arc]@row, "") + IF(Lesson@row <> "", ".l" + Lesson@row, "") + IF([Hierarchy Level]@row = "Module Overview", ".mo" + "." + [Public Facing Title]@row))))

Paul Newcome

You are not closing out the AND function before moving on to the next part of the IF statement.

What you have:

=IF(AND(........... , value if true)

What you should have:

=IF(AND(..........), value if true)