Conditional column based on two columns

[Jameswh91]

Hi,

I'm Looking to create an additional true/false column based on 2 separate columns. For example, if the sales price matches the RRP then yes, if it doesn't match then no.

Anyone know how i can achieve this?

Thannks in advance.

[Jameswh91]

Many thanks! Much appreciated!

[Vijay_A_Verma · Accepted solution]

Use following in a custom column (where sales price and RRP are your column names)

= if [sales price]=[RRP] then "Yes" else "No"