Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use nested if in expression

Greetings All,

Can aynone please suggest how to write this script in the expression :

IF(Expressions = 'Compliant' ,IF(mod(X, Y) = 0, 'Yes'),' ')

Here Expression is a field.

1 Solution

Accepted Solutions
nagaiank
Specialist III
Specialist III

Try this:

If(Expression = 'Compliant' and Mod(X,Y)=0,'Yes','')

View solution in original post

2 Replies
nagaiank
Specialist III
Specialist III

Try this:

If(Expression = 'Compliant' and Mod(X,Y)=0,'Yes','')

Not applicable
Author

Many Thnx!