Formula to check against same value dataset

[Metadata21]

Hi 

I need to create a formula for the below to replicate column K & L.

Column K looking at invoice currencies and if they match to say "correct" else "check"

Column L looking at invoice values and if they match to state "correct" else "check"

thank you all for your help! :-) 

[DataNath · Accepted solution]

@Metadata21 you can just create a couple of new fields within the Formula tool, using expressions like the following. I've just used mock data so you'll obviously need to replace Curr1/Curr2/Amount/Amount1 with your fields:

[binuacs · Accepted solution]

@Metadata21 One way of doing this

[Metadata21]

@DataNath @binuacs you guys are absolute legends - thank you!