You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

IF for multiple conditions.

Accepted answer
67
Views
9
Comments
edited Dec 1, 2020 9:26AM in Planning 9 comments

Summary

IF to be used for multiple condtions and if they are TRUE only for it to work

Content

Hi

I have a case where im using a formula to calculate values based upon two smart list values user picks upon, following is the script i have written. 

but somehow, system only considers one of my very first if condition. and other is not considered. i need to work, where if both the if conditions are TRUE, only for the formula to work. 

 

"Insurance Commision" 
(
IF("Actual Or Budget" == 10)
if ("No Of Prior Months" == Jan)
"Insurance Commision"=(("Insurance Commision New Granting Percentage")*

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!