I am unable to determine why SP keeps kicking back on error on the following.
This is a calculated column that is reading the contents of a CertQualTitle column and applying/returning the appropriate 'Number' based on the CertQualTitle to the 'DaystoRenewal' column.
Example: Firefighter I 0 Medical 1095 Fitness Test 365 Fire Officer II 0
=IF(OR(OR(OR(CQTitle="Medical",1095),CQTitle="Fitness Test",365),CQTitle="Self-Contained Breathing Apparatus Fit Test",365),CQTitle="Live Fire Refresher",720, 0)
Can someone clarify for me why the above won't deliver the desired result, please?