SP13 - Calculated columns indicator based on Choice(boolean) field

Question

I follow this tutorial step by step..

This is my formula:

="<DIV><img src='" 
&IF(Available=1,"/SiteAssets/IMG/Completed.png",
 IF(Available=0,"/SiteAssets/IMG/notCompleted.png"))& "'>
</DIV>"

Result is

• where returned value of calculated column is Single line text:

• where returned value of calculated column is Number:

Where i'm wrong? Thank you previously!!!

Answer 1

Your Formula:

="<DIV><img src='" 
 &IF(Available=1,"/SiteAssets/IMG/Completed.png",
 IF(Available=0,"/SiteAssets/IMG/notCompleted.png"))& "'>
 </DIV>"

Reformatted with linebreaks and spacing:

="<DIV><img src='" 
 &IF( Available=1
      ,"/SiteAssets/IMG/Completed.png"
      ,IF( Available=0
           ,"/SiteAssets/IMG/notCompleted.png"
         )
    )
 & "'></DIV>"

if Available is a boolean you can shorten that to:

="<DIV><img src='" 
 &IF( Available
      ,"/SiteAssets/IMG/Completed.png"
      ,"/SiteAssets/IMG/notCompleted.png"
    )
 & "'></DIV>"

and to:

="<img src='/SiteAssets/IMG/" 
 &IF( Available
      ,""
      ,"not"
    )
 & "Completed.png'>"

Now you can fix the path issue easily