CODEWITHSUNDEEP
google-sheets
marie
marie

Reputation: 231

Google Sheet columns comparison several conditions

I need to compare columns E and F The result should be in column L

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

SI(OU(E2="";E2=0); "")

I don't know how to merge the two above formulas?

If the cell is empty or equal 0, nothing should be displayed in cell L2, if E2=F2 it should say "Oui" otherwise "Non"

Also if F2 is empty L2 should be empty too...

enter image description here

Upvotes: 1

Views: 61

Answers (1)

Mike Steelson
Mike Steelson

Reputation: 15318

You can use arrayformula in L1, in FR notation

={"Comparaison MP";arrayformula(if(F2:F="";;if(E2:E=F2:F;"oui";"non")))}

enter image description here

Upvotes: 1

Related Questions