If else function

I am working on a WF where I have columns as

ABC Fund | PQR Fund |. XTZ Fund

2.0. N/A. N/A

4.0. N/A. N/A

N/A. N/A 5.0

N/A. N/A. 4.0

Now I have to add a new column and set a formula there on the basis of these 3 columns that if any of these 3 column contains any value then it should reflect in new column else N/A.

Workflow

Datasets

Download

Accepted answers

All comments

Christina_H

What do you want to see if more than one column has a value?

Tid14

New column

2.0

4.0

5.0

4.0

binay2448

Find attached solution for your question..

If else function.yxmd

vamsey

Hi Find the attached solution.

Please mark it as solved if it helps 🙂

if else.yxmd

Tid14

Thankyou for the help but this is not exactly what I am looking for.

I want in these 3 columns only 1 row will have the numeric value. So whichever column contains the value should be reflect in the NEW COLUMN.

And N/A here is Not applicable which is field name so don't think can change it to 0.

atcodedog05

Hi @Tid14

Use formula like below

IF [ABC Fund]!="N/A." THEN [ABC Fund] 
ELSEIF [PQR Fund]!="N/A." THEN [PQR Fund]
ELSEIF [XTZ Fund]!="N/A." THEN [XTZ Fund]
ELSE "N/A." ENDIF

Workflow:

Hope this helps : )

ABC.yxmd

binay2448

Find updated solution ....

If else function.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703