Please help on this formula

Help Studio
, ,
1

“IF(OR([@[CLASSIFICATION_CD]]=“FACILITY”,[@[NURSING_FACILITY]]=“YES”), “N/A”,”“)”
i am trying to fill this formula for entire column but i am getting error code of BC30198

2

Hi @nkm.rpa.1996

Try this

"=IF(OR([@[CLASSIFICATION_CD]]=""FACILITY"",[@[NURSING_FACILITY]]=""YES""), ""N/A"", """")"

Regards,

3

Hi @nkm.rpa.1996

Try this forumula:
"=IF(OR([@[CLASSIFICATION_CD]]=""FACILITY"",[@[NURSING_FACILITY]]=""YES""), ""N/A"", "")"

image
image953×769 24.8 KB

Regards

4

i tried for this on but value is not correct format see the value is “IF(OR([@[CERT_STATUS]]="N/A",[@[CERT_STATUS]]="No"),"N/A",")”

5

i tried for this on but value is not correct format “IF(OR([@[CERT_STATUS]]="N/A",[@[CERT_STATUS]]="No"),"N/A",")”

6

What are you exactly trying to compare and write can you share it with some screenshots @nkm.rpa.1996

Regards

7

see i applied double quotation but i am getting wrong format of formula and facing an issue

image

Screenshot 2024-05-31 140904
Screenshot 2024-05-31 1409041562×782 54 KB

8

Hi @nkm.rpa.1996

What are you storing in equal?

Regards

9

just this equal symbol =

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.