Math operators (`/` operator)

[Brian7]

Hi

I am using this formula with Yes = 1/ No= 0, but the Column B doesn’t give me a value. That is happen always with the column that are before the / operator.

Example:

• IFS([Column A]=YES,1)+IFS([Column B]=YES,1) / IFS(ISNOTBLANK([Column A]),0) clutter]),0)+IFS(ISNOTBLANK([Column B]),0) clutter]),0)

[Steve]

What is clutter]),0) that occurs twice in your expression?

[Steve]

IFS() will return blank if you don’t have a matching expression. Thus, IFS(ISNOTBLANK([Column A]),0) will return blank if the Column A value is blank.

[Brian7]

Sorry
You are right was a mistake.

IFS([Column A]=YES,1)+IFS([Column B]=YES,1) / IFS(ISNOTBLANK([Column A]),0) +IFS(ISNOTBLANK([Column B]),0)

The situation is that the Column B doesn’t give me a value, when I choose Yes and That happen always with the column that are before the / operator.

[Steve]

Also keep in mind order of operations. The expression you gave will be evaluated as follows:

1. IFS([Column B]=YES,1) / IFS(ISNOTBLANK([Column A]),0)

2. IFS([Column A]=YES,1)+ result of above +IFS(ISNOTBLANK([Column B]),0)