Completing elseif statement

[PrashantJP]

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 solution]

@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 solution]

Many thanks @Qiu ! Greatly appreciate!!

[Qiu]

@PrashantJP 
Glad to be helpful.

[MarqueeCrew · Accepted solution]

@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

[Qiu]

@MarqueeCrew 
Thank you for the comment and also tip for using Switch function.
I rarely using it so far, and would like to try it more. 
Answering questions here really improve myself 😁.