I have two images that are both located in my site assets folder and I want to show the two images based on when a source column returns "yes" or "no".
I have a wrapped around a nested if statement and the only results I'm getting is the first image, "yes.png". Even if the source column displays "no" the calculated column returns the "yes.png" image.
="<DIV> <IMG src='/SiteAssets/yes.png'"&IF([Source Column]= "Yes", "yes.png",IF([Calculated Column]= "No", "no.png"))&"'> </DIV>
And if I leave IMG src as just
/SiteAssets then I only get these: