Help with Nested IF statements

%3CLINGO-SUB%20id%3D%22lingo-sub-2519570%22%20slang%3D%22en-US%22%3EHelp%20with%20Nested%20IF%20statements%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2519570%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20to%20understand%20the%20following%20nested%20IF%20statement.%26nbsp%3B%20I've%20read%20a%20book%20and%20online%20Microsoft%20documentation%20and%20I'm%20not%20getting%20something.%26nbsp%3B%20%26nbsp%3B%20I%20understand%20that%201)%20how%20the%20nested%20IF%20statement%20is%20(logic%20statement%2C%20result%20if%20true%2C%20result%20if%20false)%2C%202)%20statements%20can%20be%20written%20in%20different%20ways%203)%20I%20tried%20to%20use%20my%20limited%20knowledge%20of%20IF-THEN%20statements%203)%26nbsp%3B%20I%20tried%20using%20the%20Excel%20%22Insert%20Function%22%20tool%20to%20help%20me%20and%20it%20doesn't%20help%20me%20understand.%26nbsp%3B%20%26nbsp%3BThe%20following%20formula%20works%20and%20is%20supposed%20to%20make%20SharePoint%20columns%20required%20under%20certain%20conditions%3A%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(%5BAudit%20Type%5D%3D%22P-Proposal%22%2CIF(%5BBusiness%20Review%20needed%3F%5D%26lt%3B%26gt%3B%2C%22%22%2C%20TRUE%2CFALSE)%2C%3CFONT%20color%3D%22%23FF0000%22%3E%3CSTRONG%3ETRUE%3C%2FSTRONG%3E%3C%2FFONT%3E)%3CFONT%20color%3D%22%23FF0000%22%3E%3CSTRONG%3E%3D%3C%2FSTRONG%3E%3C%2FFONT%3EIF(%5BBusiness%20Review%20needed%3F%5D%3D%22Yes%22%2CIF(%5BTask%20Status%5D%26lt%3B%26gt%3B%22%22%2CTRUE%2CFALSE)%2C%3CFONT%20color%3D%22%23FF0000%22%3E%3CSTRONG%3ETRUE%3C%2FSTRONG%3E%3C%2FFONT%3E)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20is%20bolded%20red%20is%20where%20I'm%20getting%20stuck.%26nbsp%3B%20%26nbsp%3B%20Thanks%20in%20advance%20if%20you%20can%20help%20me%20understand%20this%20statement.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20above%20is%20supposed%20to%20do%20this%3A%26nbsp%3B%20If%20user%20selects%20P-Proposal%2C%20then%20Business%20Needed%20is%20required%2C%20and%20if%20Business%20Review%20is%20selected%20then%20Task%20Status%20is%20required.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2519570%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I need help to understand the following nested IF statement.  I've read a book and online Microsoft documentation and I'm not getting something.    I understand that 1) how the nested IF statement is (logic statement, result if true, result if false), 2) statements can be written in different ways 3) I tried to use my limited knowledge of IF-THEN statements 3)  I tried using the Excel "Insert Function" tool to help me and it doesn't help me understand.   The following formula works and is supposed to make SharePoint columns required under certain conditions:  

 

=IF([Audit Type]="P-Proposal",IF([Business Review needed?]<>,"", TRUE,FALSE),TRUE)=IF([Business Review needed?]="Yes",IF([Task Status]<>"",TRUE,FALSE),TRUE)

 

What is bolded red is where I'm getting stuck.    Thanks in advance if you can help me understand this statement.   

 

The above is supposed to do this:  If user selects P-Proposal, then Business Needed is required, and if Business Review is selected then Task Status is required.   

0 Replies