Forum Discussion

kfschaefer's avatar
kfschaefer
Icon for Helper IV rankHelper IV
10 years ago
Solved

Expression error: The name 'IF' wasn't recognized. Make sure it's spelled correctly.

After numerous hours of researching this issue for 2 days, I am really stumped.   I have tried to create a simple function of either If or Switch and both return the above mentioned error.   I ev...
  • ImkeF's avatar
    ImkeF
    10 years ago

    Hi Karen,

    sorry, didn't read your question right. This will be the formula with the added condition:

     

    if [TermDate] <> null then ''Termed" else if ([#"#YearsofService"]>=2) then "2 + Years" else "Less Than 2 Years")

     

    or

     

    if [TermDate] <> "" then ''Termed" else if ([#"#YearsofService"]>=2) then "2 + Years" else "Less Than 2 Years""

Korryk's avatar
Korryk
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Ok so I'm a little confused can I note formulate like the following?

 

=IF([SubmitFiscalMonth]="FM-01 (Jul)",1,IF([SubmitFiscalMonth]="FM-02 (Aug)",2,IF([SubmitFiscalMonth]="FM-03 (Sep)",3,IF([SubmitFiscalMonth]="FM-04 (Oct)",4,IF([SubmitFiscalMonth]="FM-05 (Nov)",5,IF([SubmitFiscalMonth]="FM-06 (Dec)",6,IF([SubmitFiscalMonth]="FM-07 (Jan)",7,IF([SubmitFiscalMonth]="FM-08 (Feb)",8,IF([SubmitFiscalMonth]="FM-09 (Mar)",9,IF([SubmitFiscalMonth]="FM-10 (Apr)",10,IF([SubmitFiscalMonth]="FM-11 (May)",11,IF([SubmitFiscalMonth]="FM-12 (Jun)",12,"N/A"))))))))))))