IF for multiple conditions.
Summary
IF to be used for multiple condtions and if they are TRUE only for it to workContent
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")*
Tagged:
0