SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to insert KPI indicators from the Out of the Box SharePoint images when my slippage column is at certain points, but the indicators don't seem to be showing, please can you help me with my formula:


share|improve this question
almost a duplicate of… – Dribbel Dec 6 '10 at 10:23
up vote 1 down vote accepted
="<DIV><img src='"&IF(OR(Slippage>30,Slippage<-30),"/_layouts/images/ewr218l.gif", /* s>30 or s<-30 */
   IF( OR( AND(Slippage<=-7,Slippage>=-29),AND(Slippage>=7,Slippage<=29)),
     "/_layouts/images/ewr219l.gif",  /* true, thus -29<=s<=-7 or 7<=s<=29 */
     "/_layouts/images/ewr217l.gif"   /* false, thus -7<s<7 */  

(remove comments /* */, spaces and linebreaks before pasting)
see also:

share|improve this answer
Hi - this is great - works really well!. How do I go about adding more lines? – user1956 Dec 8 '10 at 2:04
Don't forget to vote and mark the answer as accepted :) – Dribbel Dec 13 '10 at 8:37

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.