Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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:

=IF(Slippage>30,"/_layouts/images/ewr218l.gif",IF(AND(Slippage>=-7,Slippage<=-29),"/_layouts/images/ewr219l.gif",IF(AND(Slippage>=-7,Slippage<=29),"/_layouts/images/ewr219l.gif",IF(Slippage<7,"/_layouts/images/ewr217l.gif","/_layouts/images/ewr217l.gif"))))&";'>"

share|improve this question
    
almost a duplicate of sharepointoverflow.com/questions/7256/… –  Dribbel Dec 6 '10 at 10:23
add comment

1 Answer 1

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 */  
   )
 )&"'></DIV>"

(remove comments /* */, spaces and linebreaks before pasting)
see also: http://www.sharepointoverflow.com/questions/7256/html-calculated-column-formula

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
add comment

Your Answer

 
discard

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