Facing Issue in formula

Question

I am new in coding and I am trying to learn formulas.

For the below formula:

IF
(
AND
(IsInfected__c==TRUE, Is_Patient_Dead__c==TRUE),
Min_Pay__c*0, Max_Pay__c,   

IF(
AND(IsInfected__c==TRUE, IsCured__c==TRUE)
,Max_Pay__c,Min_Pay__c))

I get following Error:

Incorrect number of parameters for function 'IF()'. Expected 3, received 4. If I add one more parentheses, it shows me another error ' Syntax error. Extra ')'

Answer 1

please re - phrase the formula

IF((IsInfected__c==TRUE && Is_Patient_Dead__c==TRUE),0,IF((IsInfected__c==TRUE && IsCured__c==TRUE),Max_Pay__c,Min_Pay__c))

above formula will achieve the below use cases:

use case 1 : if patient is infected and dead, no payment

use case 2 : if patient is infected and cured, either pay maximum or minimum based on the treatment.

hope this helps

Answer 2

If statements require three parameters, the condition, the value if true, then the value if false. You have four parameters.

1. AND(IsInfected__c==TRUE, Is_Patient_Dead__c==TRUE)
2. Min_Pay__c*0
3. Max_Pay__c
4. IF( AND(IsInfected__c==TRUE, IsCured__c==TRUE) ,Max_Pay__c,Min_Pay__c)

I'm not sure what you meant to do, but you have an extra value you need to get rid of.

Also, a Boolean value is already a Boolean value, so you can simply say:

• IsInfected__c
• IsCured__c

Rather than comparing the value to TRUE.