Compare two columns and display "Yes" or "no"-CodePudding

Home > Net > Compare two columns and display "Yes" or "no"

Compare two columns and display "Yes" or "no"

Time：04-05

I want to compare column E and F but the "Vrai" should be "Oui" I can't figure how to change the formula?

I'am using =ET(E2=F2)

I was expecting doing something like : =SI(E2=F2; "Oui", "Non" but it ain't working...

Help is very welcome

CodePudding user response：

In google sheets

=SI(E2=F2; "Oui"; "Non")

should work...