You need to sign in to do that
Don't have an account?
Amanda Jones
How to make one IF Statement apply to all others?
Hello!
I am trying to update a formula field so that one if statement adds a dollar amount to all of the others.
Here is the statement that should apply to all of the others IF(Extra_Night__c =True), 15.00
But I can't get it to work when I add it in. When I check the Extra Night box, it only returns the 15.00 value, not the 15.00 plus the other amounts.
IF(
ISPICKVAL(Status, "Cancelled"),0,
IF((
ISPICKVAL (UP_City__c,"Dallas, TX")&&NumberSent>10 && UP_Auto_Number_of_Nights__c>= 4||
ISPICKVAL(UP_City__c,"Des Moines, IA")&&NumberSent>10 && UP_Auto_Number_of_Nights__c>= 4||
ISPICKVAL(UP_City__c, "Kansas City, MO")&&NumberSent>10 && UP_Auto_Number_of_Nights__c>= 4||
ISPICKVAL(UP_City__c, "Sioux Falls, SD")&&NumberSent>10 && UP_Auto_Number_of_Nights__c>= 4||
ISPICKVAL(UP_City__c, "Ocean Beach, CA")&&NumberSent>10 && UP_Auto_Number_of_Nights__c>= 4||
ISPICKVAL(UP_City__c, "Storm Lake, IA")&&NumberSent>10 && UP_Auto_Number_of_Nights__c>= 4||
ISPICKVAL(UP_City__c, "Phoenix, AZ")&&NumberSent>10 && UP_Auto_Number_of_Nights__c>= 4||
ISPICKVAL(UP_City__c, "Las Vegas, NV")&&NumberSent>10 && UP_Auto_Number_of_Nights__c>= 4||
ISPICKVAL(UP_City__c, "Chicago, IL")&&NumberSent>10 && UP_Auto_Number_of_Nights__c>= 4||
ISPICKVAL(UP_City__c, "Lincoln, NE")&&NumberSent>10 && UP_Auto_Number_of_Nights__c>= 4
), 20.00*NumberSent,
IF(VALUE(TEXT(Year__c))>=2018 &&ISPICKVAL(UP_City__c,"Omaha, NE")&&ISPICKVAL(Coordinator_First_Name__c,"Jordan"), 90.00,
IF (VALUE(TEXT(Year__c))<=2018 &&ISPICKVAL(UP_City__c,"Omaha, NE")&&ISPICKVAL(Coordinator_First_Name__c, "Marcus"),75.00,
IF (VALUE(TEXT(Year__c))>=2019 &&ISPICKVAL(UP_City__c,"Omaha, NE")&&ISPICKVAL(Coordinator_First_Name__c, "Marcus"),80.00,
IF (UP_Auto_Number_of_Nights__c<1 && NumberSent>10 ,5.00*NumberSent,
IF (UP_Auto_Number_of_Nights__c<1 && NumberSent<=10,5.00*10,
IF (UP_Auto_Number_of_Nights__c=2&& NumberSent<=10, 15.00*10,
IF (UP_Auto_Number_of_Nights__c=2 && NumberSent>10 ,15.00*NumberSent,
IF (UP_Auto_Number_of_Nights__c=3&& NumberSent<=10, 15.00*10,
IF (UP_Auto_Number_of_Nights__c=3&& NumberSent>10 ,15.00*NumberSent,
20.00*10
)))))))))))
I am trying to update a formula field so that one if statement adds a dollar amount to all of the others.
Here is the statement that should apply to all of the others IF(Extra_Night__c =True), 15.00
But I can't get it to work when I add it in. When I check the Extra Night box, it only returns the 15.00 value, not the 15.00 plus the other amounts.
IF(
ISPICKVAL(Status, "Cancelled"),0,
IF((
ISPICKVAL (UP_City__c,"Dallas, TX")&&NumberSent>10 && UP_Auto_Number_of_Nights__c>= 4||
ISPICKVAL(UP_City__c,"Des Moines, IA")&&NumberSent>10 && UP_Auto_Number_of_Nights__c>= 4||
ISPICKVAL(UP_City__c, "Kansas City, MO")&&NumberSent>10 && UP_Auto_Number_of_Nights__c>= 4||
ISPICKVAL(UP_City__c, "Sioux Falls, SD")&&NumberSent>10 && UP_Auto_Number_of_Nights__c>= 4||
ISPICKVAL(UP_City__c, "Ocean Beach, CA")&&NumberSent>10 && UP_Auto_Number_of_Nights__c>= 4||
ISPICKVAL(UP_City__c, "Storm Lake, IA")&&NumberSent>10 && UP_Auto_Number_of_Nights__c>= 4||
ISPICKVAL(UP_City__c, "Phoenix, AZ")&&NumberSent>10 && UP_Auto_Number_of_Nights__c>= 4||
ISPICKVAL(UP_City__c, "Las Vegas, NV")&&NumberSent>10 && UP_Auto_Number_of_Nights__c>= 4||
ISPICKVAL(UP_City__c, "Chicago, IL")&&NumberSent>10 && UP_Auto_Number_of_Nights__c>= 4||
ISPICKVAL(UP_City__c, "Lincoln, NE")&&NumberSent>10 && UP_Auto_Number_of_Nights__c>= 4
), 20.00*NumberSent,
IF(VALUE(TEXT(Year__c))>=2018 &&ISPICKVAL(UP_City__c,"Omaha, NE")&&ISPICKVAL(Coordinator_First_Name__c,"Jordan"), 90.00,
IF (VALUE(TEXT(Year__c))<=2018 &&ISPICKVAL(UP_City__c,"Omaha, NE")&&ISPICKVAL(Coordinator_First_Name__c, "Marcus"),75.00,
IF (VALUE(TEXT(Year__c))>=2019 &&ISPICKVAL(UP_City__c,"Omaha, NE")&&ISPICKVAL(Coordinator_First_Name__c, "Marcus"),80.00,
IF (UP_Auto_Number_of_Nights__c<1 && NumberSent>10 ,5.00*NumberSent,
IF (UP_Auto_Number_of_Nights__c<1 && NumberSent<=10,5.00*10,
IF (UP_Auto_Number_of_Nights__c=2&& NumberSent<=10, 15.00*10,
IF (UP_Auto_Number_of_Nights__c=2 && NumberSent>10 ,15.00*NumberSent,
IF (UP_Auto_Number_of_Nights__c=3&& NumberSent<=10, 15.00*10,
IF (UP_Auto_Number_of_Nights__c=3&& NumberSent>10 ,15.00*NumberSent,
20.00*10
)))))))))))
All Answers