How to display images in SharePoint 2013 Calculated Column in List- help with syntax please

Question

I need to display images in a SharePoint 2013 list based on the following criteria:

If 'Member' Column = yes then display Green tick icon (URL listed below)

If 'Member' Column = no then display red cross icon (URL listed below)

I need some assistance with my Formula based on the first criteria only and it keeps producing errors:

="<DIV><imgsrc='"&IF[Member]="Yes","http://isourcedev.walfs.local/sites/wfin/SiteAssets/Tick%20Green%20Circle.png"))&"'></DIV>"

I would appreciate some help with the syntax as I am very new to this and think its to do with lack of brackets etc.Thanks in Advance.

SharePoint user.

Answer 1

You Can try this code to achieve your functionality:

="<div><img style='float: left' src='http://isourcedev.walfs.local/sites/wfin/SiteAssets/"
&IF(Member="Yes"
;"Tick%20Green%20Circle.png"
;IF(Member="No"
;"Tick%20Red%20Circle.png"
)
)
&"'></div>"

Source: Images in calculated columns

Also you can try this code if your choice is restricted to Yes/No :

="<DIV><img src='http://isourcedev.walfs.local/sites/wfin/SiteAssets/"&IF([Completed?], "Tick%20Green%20Circle.png", "Tick%20Red%20Circle.png")&"'></DIV>"

Source: Using a Calculated Column to show Images

If You need empty for Member = No

=IF([Member?], "<DIV><img src='http://isourcedev.walfs.local/sites/wfin/SiteAssets/Tick%20Green%20Circle.png/><DIV>", "")