+ Start a Discussion
Adam SamuelAdam Samuel 

Issues using the IF function when creating a formula field

Hi there,
Sorry if this is obvious and maybe I've been sitting oin front of the computer too long, but I'm having trouble writing a string of "IF" statements.

I'm trying to say...  
IF field => 1 and <=4 then write "New", otherwise write "Nil" & 
IF field => 5 and <=9 then write "Newer", otherwise write "Nil" & 
IF field => 10 and <=14 then write "Newest", otherwise write "Nil" & 

so on...

Can someone help me please?

Kind regards,
Adam
Vivek DVivek D
I would suggest you use process builder in this case to update a field. Becuase as your condition says so on.. it can reach to 5000 character limit.