Divide IF

[insomned]

Hello, 

I want to divide one column by another IF that column contains certain data and output the result in a new column. 

Sarah    1 10

Bill         5  10

I would like to divide 1/10 if the [Name] column = "Sarah". Thank you! 

[Emil_Kos]

Hi @insomned ,

I have created a workflow for you and in the workflow, I included two ways of doing it.

Basicly you need to write down this formula:

IF [Name]='Sarah' THEN [Column 1]/[Column 2] ELSE Null() ENDIF

First, we are checking the condition. Afterwards, we are doing calculations. If the criteria weren't met we put a null value.

[binay2448]

Find my solution attached...