Comment utiliser la fonction dans Google Sheets selon plusieurs critères ? Par exemple, pour avoir "OUI", il faut que A2 = 2 ET B2 = NON ? On a deux critères.. La fonction logique IFS nous permet d'évaluer plusieurs conditions et affiche une valeur correspondant à la première condition qui est vraie.
:max_bytes(150000):strip_icc()/GoogleSheetsANDFunction-c269e2e806c74408a4b8259acc8b9019.jpg "Test Multiple Conditions Using AND/OR in Google Sheets")
![Highlight Duplicates in Multiple Columns in Google Sheets [2024]](https://assets-global.website-files.com/62b4c5fb2654ca30abd9b38f/6432fc8b6b91985325c78e42_wEKznFAQt1t7_TsyVJk0uVEMrMAt0yiKwi6zbxjOtoOD-fKVIHKxXF5II8w8Co8Q-w4L8wD6mFwYhqkHAnCZYTVsJ6dw2jz9_Ily6h1UT5z0BpRZcTt0rB5LdwOV9zS7t6JALnjs_Pv8JFWsxqjF604.png "Highlight Duplicates in Multiple Columns in Google Sheets [2024]")
One of the first formulas I started with when exploring more about the functionality of spreadsheets is the IF formula. The IF formula is easy to understand and contains only three parameters which are all required. The first parameter is the condition to check, the second is the returned value if the condition is true, and the third parameter is the returned value if the condition evaluates.. In this new beginner's tutorial video, we will see how to manage an IF function with multiple conditions (returning different values depending on the condition met) in #googlesheets .