• WC1265
  • NEWBIE
  • 0 Points
  • Member since 2007

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
Cannot get advanced formula to validate syntex.  Need the below formula to calculate as such: If unit dose actual is less than or equal to unit dose base, multiply unit dose actual by $10.  If unit dose actual is greater than unit dose base and less than unit dose target, multiply unit dose actual by $30.  If unit dose actual is greater than or equal to unit dose target, multiply unit dose actual by $40.
 
Formula is currently written as such:

IF(Unit_Dose_Act__c <=  Unit_Dose_Base__c),Unit_Dose_Act__c*10,

IF(AND(Unit_Dose_Act__c> Unit_Dose_Base__c,Unit_Dose_Act__c<Unit_Dose_Target__c),  Unit_Dose_Act__c *30), IF(Unit_Dose_Act__c>=  Unit_Dose_Target__c),Unit_Dose_Act__c *40

 

Any help would be greatly appreciated.  Thanks!

  • October 23, 2007
  • Like
  • 0
Cannot get advanced formula to validate syntex.  Need the below formula to calculate as such: If unit dose actual is less than or equal to unit dose base, multiply unit dose actual by $10.  If unit dose actual is greater than unit dose base and less than unit dose target, multiply unit dose actual by $30.  If unit dose actual is greater than or equal to unit dose target, multiply unit dose actual by $40.
 
Formula is currently written as such:

IF(Unit_Dose_Act__c <=  Unit_Dose_Base__c),Unit_Dose_Act__c*10,

IF(AND(Unit_Dose_Act__c> Unit_Dose_Base__c,Unit_Dose_Act__c<Unit_Dose_Target__c),  Unit_Dose_Act__c *30), IF(Unit_Dose_Act__c>=  Unit_Dose_Target__c),Unit_Dose_Act__c *40

 

Any help would be greatly appreciated.  Thanks!

  • October 23, 2007
  • Like
  • 0