Multiple IF statements in a formula

Could someone please help troubleshoot this?

I’m trying to calculate an expiration date based on the service provided. I believe I shouldn’t really be using “or” here, but included this just to help illustrate what I’m trying to do. Each IF statement works individually but not when I try to string them together.

I have about 10 of these conditions that I’d like to check for.

IF({Service}=‘Heartguard Plus’,(DATEADD({Date Expires},1,“Month”)))
IF({Service}=‘Annual Exam’,(DATEADD({Date Expires},1,“Year”)))
IF({Service}=‘3 year Rabies’,(DATEADD({Date Expires},3,“Year”)))

Thanks for your help!

I recommend you use a SWITCH instead.

  'Heartguard Plus', DATEADD({Date Expires},1,"Month"),
  'Annual Exam', DATEADD({Date Expires},1,"Year"),
  '3 year Rabies', DATEADD({Date Expires},3,"Year")
1 Like

Oh that looks much easier! I’ll give that a shot, thanks!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.