Completing elseif statement

Question

Hi Folks,

I am unable to completely execute my elseif statement. Could you please help me with the same.

If [NAV Entry By] = "D488159" then "Sachin"

elseif [NAV Entry By] = "R692964" then "Sandeep"

elseif [NAV Entry By]= "D603496" then "Divya"

elseif [NAV Entry By] = "I741128" then "Prashant"

elseif [NAV Entry By] = "R605432" then "Khushnuma"

elseif [NAV Entry By] = "N711552" then "Ninad"

elseif [NAV Entry By] = "E451667" then "Ritika"

elseif [NAV Entry By] = "V639741" then "Savio"

else if [NAV Entry By] = "V229532" then "Joshua"

else "Blank"

endif

Qiu · Accepted Answer

@PrashantJP 
I think it is simply because there is an exra space between the last "Else if".
And for this case, I would recommend using of Find and Replace tool as below, which is easy for maintenance by adding more entries without modifying the formulas.

PrashantJP · Accepted Answer

Many thanks @Qiu ! Greatly appreciate!!

MarqueeCrew · Accepted Answer

@PrashantJP ,

@Qiu  quickly identified the root-cause of your Else If dilemma. I like to use a FIND REPLACE tool instead of a long list of replacements.  The tool allows you to append the name instead of replacing.  But there is also SWITCH().  It uses fewer keystrokes to write and never worries about the space.

Switch([NAV Entry By],"Blank", "D488159","Sachin","98765","Qui","C12345","MarqueeCReW")

cheers,

mark