+ Start a Discussion
kjunkjun 

trying to create a formula that will not allow a user to enter a value of 20% or lower

I've created this VR that will prevent a user from entering a value over 100. Is it possible to add to the syntax that would also not allow a user to enter a value of less than 20%? 
 
Percent_Value__c  > 1

 
Best Answer chosen by kjun
Maharajan CMaharajan C
Hi,

Try the below one it will work:

Percent_Value__c  < 0.2

=======================


If you want to restrict the percentage only between 20% and 100% then use the below one:

OR(
Percent_Value__c  > 1.0,
Percent_Value__c  < 0.2
)



Thanks,
Maharajan.C