This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

How to create IF Formula between 2 table

Posted on 04-10-2020 10:32 PM
Yayasan_TL_BP
New Member
Reply posted on --/--/---- --:-- AM

I have 2 table

  • pcr table
  • lpj table

i want to create formula on pcr table in column status_pcr, with lpj table in column status_lpj as reference, i use IF formula in column status_pcr = IF((lpj,[status_lpj])=“Open”,“Open”,“Closed”), but the formula doesn’t work.

How to create right formula between table?

Need your help

0 1 254
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
hru
Gold 1
Gold 1
Reply posted on --/--/---- --:-- AM

Can you give more information, such as the snapshot of both tables, what it the relation between the two tables, and where do you want to put this formula?


Top Labels in this Space