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
AAIAAI 

formula text and if condition: Syntax error

Hi all,

I would need help with this formula. I get a message: Syntax error. Any idea, please?

IF ( PotentialCOMAPABudget__c  < 200.000,"Bajo",

IF ( PotentialCOMAPABudget__c > 200.000 < 1.000.000, "Medio", 

IF ( PotentialCOMAPABudget__c > 1.000.000, "Alto",

IF (  PotentialCOMAPABudget__c > 5.000.000, "Key Account", null

)
)
)
)
Best Answer chosen by AAI
Akhil AnilAkhil Anil
Give this one a shot !
  
IF(
PotentialCOMAPABudget__c > 5000000,
"Key Account",
IF(
PotentialCOMAPABudget__c > 1000000,
"Alto",
IF(
PotentialCOMAPABudget__c > 200000,
"Medio",
IF(
PotentialCOMAPABudget__c > 0,
"Bajo",
NULL
)
)
)
)

 

All Answers

Akhil AnilAkhil Anil
Can you try this ?
  
IF(
PotentialCOMAPABudget__c > 5.000.000,
"Key Account",
IF(
PotentialCOMAPABudget__c > 1.000.000,
"Alto",
IF(
PotentialCOMAPABudget__c > 200.000,
"Medio",
IF(
PotentialCOMAPABudget__c > 0,
"Bajo",
NULL
)
)
)
)

 
Ankur Saini 9Ankur Saini 9
Hi Amaya,

try this:--

IF ( Marks__c < 200.000,"Bajo", 

IF ( Marks__c > 200.000 && Marks__c < 1000.000, "Medio", 

IF ( Marks__c > 1000.000, "Alto", 

IF ( Marks__c > 5000.000, "Key Account", null 

) 
) 
) 
)

Thanks,
Ankur Saini
AAIAAI
Sorry guys,

I am afraid that´s it doesn´t work. The formula doesn´t update the values. 

Any help??

Many thanks
Akhil AnilAkhil Anil
Give this one a shot !
  
IF(
PotentialCOMAPABudget__c > 5000000,
"Key Account",
IF(
PotentialCOMAPABudget__c > 1000000,
"Alto",
IF(
PotentialCOMAPABudget__c > 200000,
"Medio",
IF(
PotentialCOMAPABudget__c > 0,
"Bajo",
NULL
)
)
)
)

 
This was selected as the best answer
AAIAAI
Many thanks Akhil...

Now, it works perfectly

Regards,
Pathan SPathan S
1.I want  workflow rule and 2.Process builder cretirea..for .In a Account object have one custom field "No of contacts_C", when i create a new contact then 'no of contact' field need to be update no.of contact are .plz reply