Sign Up ›
  • Mission Teams Department
  • NEWBIE
  • 0 Points
  • Member since 2017
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 3
    Replies
7 replies

Formula not calculating properly

Hello,
I am trying to create a formula to calculate a cost for if a headcount is less than or equal to 10 and if a headcount is greater than 10. Below is the formula that has been created. The formula will calculate the first half (if the headcount is more than 10), but not the second half (if the headcount is less than 10). Any help is appreciated. 

IF(ISPICKVAL(Housing__c, "Kansas City - Hope Faith") || ISPICKVAL(Housing__c, "Kansas City - Bread of Life ($10.00)") || ISPICKVAL(Housing__c, "Kansas City - Sanctuary of Hope") || ISPICKVAL(Housing__c, "Des Moines - Luther Memorial") || ISPICKVAL(Housing__c, "Omaha- Faith Westwood") || ISPICKVAL(Housing__c, "Omaha- St. Andrews UMC") || ISPICKVAL(Housing__c, "Las Vegas - YWAM")|| ISPICKVAL(Housing__c, "Las Vegas - Barry Glaser’s house")|| ISPICKVAL(Housing__c, "Phoenix Dream Center") && (NumberSent>10) ,10.00 * UP_Auto_Number_of_Nights__c *  NumberSent,

IF(ISPICKVAL(Housing__c, "Kansas City - Hope Faith") || ISPICKVAL(Housing__c, "Kansas City - Bread of Life ($10.00)") || ISPICKVAL(Housing__c, "Kansas City - Sanctuary of Hope") || ISPICKVAL(Housing__c, "Des Moines - Luther Memorial") || ISPICKVAL(Housing__c, "Omaha- Faith Westwood") || ISPICKVAL(Housing__c, "Omaha- St. Andrews UMC") || ISPICKVAL(Housing__c, "Las Vegas - YWAM")|| ISPICKVAL(Housing__c, "Las Vegas - Barry Glaser’s house")|| ISPICKVAL(Housing__c, "Phoenix Dream Center") && (NumberSent<=10) ,10.00 * UP_Auto_Number_of_Nights__c *  10,

IF (ISPICKVAL(Housing__c, "Omaha - Better Together Campus"), 10.00*UP_Auto_Number_of_Nights__c *NumberSent,

IF (ISPICKVAL(Housing__c, "Dallas - Cornerstone Baptist"), 10.00*UP_Auto_Number_of_Nights__c * NumberSent,0))))
7 replies

Formula not calculating properly

Hello,
I am trying to create a formula to calculate a cost for if a headcount is less than or equal to 10 and if a headcount is greater than 10. Below is the formula that has been created. The formula will calculate the first half (if the headcount is more than 10), but not the second half (if the headcount is less than 10). Any help is appreciated. 

IF(ISPICKVAL(Housing__c, "Kansas City - Hope Faith") || ISPICKVAL(Housing__c, "Kansas City - Bread of Life ($10.00)") || ISPICKVAL(Housing__c, "Kansas City - Sanctuary of Hope") || ISPICKVAL(Housing__c, "Des Moines - Luther Memorial") || ISPICKVAL(Housing__c, "Omaha- Faith Westwood") || ISPICKVAL(Housing__c, "Omaha- St. Andrews UMC") || ISPICKVAL(Housing__c, "Las Vegas - YWAM")|| ISPICKVAL(Housing__c, "Las Vegas - Barry Glaser’s house")|| ISPICKVAL(Housing__c, "Phoenix Dream Center") && (NumberSent>10) ,10.00 * UP_Auto_Number_of_Nights__c *  NumberSent,

IF(ISPICKVAL(Housing__c, "Kansas City - Hope Faith") || ISPICKVAL(Housing__c, "Kansas City - Bread of Life ($10.00)") || ISPICKVAL(Housing__c, "Kansas City - Sanctuary of Hope") || ISPICKVAL(Housing__c, "Des Moines - Luther Memorial") || ISPICKVAL(Housing__c, "Omaha- Faith Westwood") || ISPICKVAL(Housing__c, "Omaha- St. Andrews UMC") || ISPICKVAL(Housing__c, "Las Vegas - YWAM")|| ISPICKVAL(Housing__c, "Las Vegas - Barry Glaser’s house")|| ISPICKVAL(Housing__c, "Phoenix Dream Center") && (NumberSent<=10) ,10.00 * UP_Auto_Number_of_Nights__c *  10,

IF (ISPICKVAL(Housing__c, "Omaha - Better Together Campus"), 10.00*UP_Auto_Number_of_Nights__c *NumberSent,

IF (ISPICKVAL(Housing__c, "Dallas - Cornerstone Baptist"), 10.00*UP_Auto_Number_of_Nights__c * NumberSent,0))))