ARR Asked: 2020-10-05 06:39:01 +0800 CST 2020-10-05 06:39:01 +0800 CST 2020-10-05 06:39:01 +0800 CST Add an AND in the IF function in Excel 772 I need to create a function in which it says: SI porcentaje_cruce >= 80 Y Claificación_final >= 50% entonces 2000 si no es 0. excel 1 Answers Voted Best Answer user75901 2020-10-05T06:52:58+08:002020-10-05T06:52:58+08:00 The use of the function Yor ANDin English goes within the main function, which in this case is SIor IFin English So your formula should look like this =SI(Y(C6>=80, D6>=50), 2000, 0) Since we are going to put SIa double comparison inside it, then we separate them both only by a comma I consider it valid to answer you because you have in your question the idea of how the comparison would be in pseudocode
The use of the function
Y
orAND
in English goes within the main function, which in this case isSI
orIF
in EnglishSo your formula should look like this
Since we are going to put
SI
a double comparison inside it, then we separate them both only by a commaI consider it valid to answer you because you have in your question the idea of how the comparison would be in pseudocode