function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Christina Lam 7Christina Lam 7 

Converting Percentage to Number

Hello! What is the best approach to convert a percentage into a number between two fields? For instance, if Field A is 60%, then Field B would indicate a number based on Field A's 60%. In Field B, 1=90-100%, 2=80-90%, 3=60-80%, 4=40-60%, 5=20-40%, 6=0-20%. 

I tried a CASE formula, however when I type in a decimal for a percentage, there is a syntax error. Thanks!
Raj VakatiRaj Vakati
Try some think linke this 

Using nested ifs and add other conditions  
IF(
AND(A__c >90 ,A__c<100) , 1 , 
IF( AND(A__c >90 ,A__c<60) , 2 ,0 ))

 
Christina Lam 7Christina Lam 7
Hi Raj,

I tried your formula, but Field B is still coming up as a blank number. Do you have any suggestions on why this might not be working? Thanks!