ShowAll Questionssorted byDate Posted
AAI

# 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

)
)
)
)
Akhil 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
)
)
)
)```

Akhil 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 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
AAI
Sorry guys,

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

Any help??

Many thanks
Akhil 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
AAI
Many thanks Akhil...

Now, it works perfectly

Regards,
Pathan 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