 # Math operators (`/` operator)

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)

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

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.

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.

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)`