I want to calculate a Due Date based on a defined Frequency.
Audit frequencies are Annually, Biennially or Triennially. I have used the following formula but I get the #UNPARSEABLE output.
=IF([Audit Frequency]@row=Biennially, "[Last Audit Date]@row+730", IF([Audit Frequency]@row=Triennially, "[Last Audit Date]@row+1095", IF([Audit Frequency]@row=Annually, "[Last Audit Date]@row+365", "N/A")))
Best Answer

@Doris F Try this.
=IF([Audit Frequency]@row="Biennially", [Last Audit Date]@row+730, IF([Audit Frequency]@row="Triennially", [Last Audit Date]@row+1095, IF([Audit Frequency]@row="Annually", [Last Audit Date]@row+365, "N/A")))
Answers

@Doris F Try this.
=IF([Audit Frequency]@row="Biennially", [Last Audit Date]@row+730, IF([Audit Frequency]@row="Triennially", [Last Audit Date]@row+1095, IF([Audit Frequency]@row="Annually", [Last Audit Date]@row+365, "N/A")))

@Lindsay AR  THANK YOU!!!
Help Article Resources
Categories
Check out the Formula Handbook template!