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""

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi kfschaefer,

 

   is as Sean and ImkeF said. Take a look at this examples:

 

Excelguru

Technet

 

Just remember as ImkeF said that M is very case sensitive so you have to write:   if (. . .) then (. . .) else (. . .)

 

 

#I'M Not An Expert#