Hi there, been trying but to no avail.how do i pick a specific cell from an excel tab if a IF formula logic i used in excel is fulfilled? E.g if type =buy then get cell from buy(1) else sell (1) Noidtest accountTYPEC_P_BUYbuyC_Y_SELLsell15268663123BUYKRW66666USD12325268663234BUYKRW7777USD44435268663555SELLUSD8888KRW55545268663666SELLUSD9999KRW666 Im working all this logic in excel in another tab based on the excel tab above. Thanks for the help.

How to retrieve a cell based on a IF logic formula in excel?

Hi there,

been trying but to no avail.how do i pick a specific cell from an excel tab if a IF formula logic i used in excel is fulfilled?

E.g if type =buy then get cell from buy(1) else sell (1)

No	id	test account	TYPE	C_P_BUY	buy	C_Y_SELL	sell
1	5268663	123	BUY	KRW	66666	USD	123
2	5268663	234	BUY	KRW	7777	USD	444
3	5268663	555	SELL	USD	8888	KRW	555
4	5268663	666	SELL	USD	9999	KRW	666

Im working all this logic in excel in another tab based on the excel tab above.

Thanks for the help.

Data Investigation

Accepted answers

RolandSchubert

Hi @keepcalm ,

are you trying to replicate an Excel formula like

= IF(D5='BUY', $F$2, $H$2) => for all rows, one of two specific values is selected depending on the value in a definied column of this row

(counted columns/rows "Excel-like" starting with "No" as A1)

An easy option is to select the values needed (comparable to $F$2 and $G$2), use the "Append Fields" tool to add these values to all rows and use the formula @echuong1 suggested. I've attached a sample workflow.

Does this help?

Best,

Roland

CellBasedValue.yxmd

All comments

echuong1

You can achieve this through a formula tool. See attached for an example.

New Workflow6.yxmd

DiganP

@keepcalm @echuong1 described the easiest method.

You can learn more about the conditional statements or formula functions in general here.

keepcalm

No	id	test account	TYPE	C_P_BUY	buy	C_Y_SELL	sell
1	5268663	123	BUY	KRW	66666	USD	123
2	5268663	234	BUY	KRW	7777	USD	444
3	5268663	555	SELL	USD	8888	KRW	555
4	5268663	666	SELL	USD	9999	KRW	666

@DiganP and @euchong1 I would like to get a specific cell e.g buy(1) i.e 66666 if it fulfill the logic.Do note that the table are not fixed which emphasize need to retrieve from a specific cell. Appreciate the help!

RolandSchubert

Hi @keepcalm ,

are you trying to replicate an Excel formula like

= IF(D5='BUY', $F$2, $H$2) => for all rows, one of two specific values is selected depending on the value in a definied column of this row

(counted columns/rows "Excel-like" starting with "No" as A1)

Does this help?

Best,

Roland

CellBasedValue.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703