• WC1265
• NEWBIE
• 0 Points
• Member since 2007

• Chatter
Feed
• 0
• 0
• 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