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
StaceyUSStaceyUS 

How do use a range of numbers within a formula field?

Hello,

 

I am need of assistance for a formula field that is based off a Picklist field which would then populate with specified text.

 

SIC Code range is 0111 - 1499 and if the range is True then the Industry field would populate to Agriculture/Forestry/Fishing/Mining 01 - 14.  My existing formula does work when I specify one SIC Code.

 

This is what I have so far:

 

IF((ISPICKVAL(SIC_Code__c, "<= 1499")), "Agriculture/Forestry/Fishing/Mining 01 - 14", NULL)

 

I tried to start off with one line first and then once that worked I will extend the formula with the other ranges and values.

 

Any help is greatly appreciated.

 

Stacey

Ritesh AswaneyRitesh Aswaney

IF(VALUE(TEXT(SIC_Code__c)) <= 1499, ....., ....