IF Condition Help

Need a help on the IF condition, have attached my request in png file. I am stuck on this for long time. If it is one time then the reference from 1 & 2 based on non zero i need to update the output as 1 & 2 respectively otherwise it shall be blank.

Please help

Regards

Raj

Common Use Cases

Accepted answers

estherb47

Hi Raj,

I'm not sure I'm understanding your request. Would you fill the table with the answers you desire?

Here's a go in any case

IF [One time]="One time" THEN

IF [1]!=0 THEN 1
ELSEIF [2]!=0 THEN 2

ELSE ""

ENDIF

ELSE ""

ENDIF

All comments

estherb47

Hi Raj,

I'm not sure I'm understanding your request. Would you fill the table with the answers you desire?

Here's a go in any case

IF [One time]="One time" THEN