Build Lead Score and Rating Fields

Lead_Score
------------------------------------------------------------------------------------------------------------
IF(
ISBLANK( TEXT(Status) ), null,
IF( ISPICKVAL(Status, 'Closed - Not Converted'), 0,
IF( DoNotCall, -25, 0 ) +
IF( ISBLANK(Email), 0, 15 ) +
CASE( TEXT(LeadSource),
'Web', 20,
'Phone Inquiry', 35,
'Partner Referral', 25,
'Purchased List', 10,
0
)))

-----------------------------------or-------------------------------------------------------
IF(
    ISBLANK( TEXT( Status ) ),
    null,
    IF(
        ISPICKVAL( Status , 'Closed - Not Converted'),
        0,
        IF(
            DoNotCall,
            -25,
            0
        )  +
        IF(
            ISBLANK( Email),
            0,
            15
        ) +
        CASE(
            TEXT( LeadSource ),
            'Web', 20,
            'Phone Inquiry', 35,
            'Partner Referral', 25,
            'Purchased List',10,
            0
        )
    )
)



Lead_Rating
------------------------------------------------------------------------------------------------------
IF(

Lead_Score__c < 10, IMAGE("/img/samples/stars_000.gif", "0 Star", 1, 2),

IF(

AND(Lead_Score__c >= 10, Lead_Score__c < 19), IMAGE("/img/samples/stars_100.gif", "1 Star", 1, 2),

IF(

AND(Lead_Score__c >= 20, Lead_Score__c < 29), IMAGE("/img/samples/stars_200.gif", "2 Star", 1, 2),

IF(

AND(Lead_Score__c >= 30, Lead_Score__c < 39), IMAGE("/img/samples/stars_300.gif", "3 Star", 1, 2),

IF(

AND(Lead_Score__c >= 40, Lead_Score__c < 49), IMAGE("/img/samples/stars_400.gif", "4 Star", 1, 2),

IF(

Lead_Score__c > 50, IMAGE("/img/samples/stars_500.gif", "5 Star", 1, 2),

null

)

)

)

)

)

)


----------------------------------------or------------------------------------------------------


CASE(
    FLOOR(Lead_Score__c / 10) * 10,
    0, IMAGE("/img/samples/stars_000.gif", "0 Star"),
    10, IMAGE("/img/samples/stars_100.gif", "1 Star"),
    20, IMAGE("/img/samples/stars_200.gif", "2 Star"),
    30, IMAGE("/img/samples/stars_300.gif", "3 Star"),
    40, IMAGE("/img/samples/stars_400.gif", "4 Star"),
    50, IMAGE("/img/samples/stars_500.gif", "5 Star"),
    IMAGE("/img/samples/default-image.gif", "Unknown")
)