+ Start a Discussion
srikanth nsrikanth n 

Hi friends I need Help on validation rule u Guys.... My Requirement Is Like

Hi friends I need Help on validation rule u Guys....
My Requirement Is Like
Employees No :10
If Employee Get “A” Grade The Hike Percentage is 10
If Employee Get “B” Grade The Hike Percentage is 20
If Employee Get “C” Grade The Hike Percentage is 30
If Employee Get “D” Grade The Hike Percentage is 40
If Employee Get “E” Grade The Hike Percentage is 50
How to Write for this and how to write for Grade to get A, B. C, D, E values automatically …..
Chandra PrakashChandra Prakash
Hi Srikant n ,
please try this validation rule

Fistly you create Picklist and add value {A,B,C,D,E}

For Ex : 

IF(ISPICKVAL(  Grade__c , 'A'),"10",IF(ISPICKVAL(Grade__c, 'B'),"20",IF(ISPICKVAL(Grade__c, 'C'),"30",IF(ISPICKVAL(Grade__c,'D'),"40",IF(ISPICKVAL(Grade__c,'E'),"50","0")))))


Thanks
----------
Chandra Prakash Sharma
Bisp Solutions Inc.