I need to create a function in which I say:
SI porcentaje_cruce >= 80 Y Claificación_final >= 50% entonces 2000 si no es 0.
I need to create a function in which I say:
SI porcentaje_cruce >= 80 Y Claificación_final >= 50% entonces 2000 si no es 0.
The use of the function Y or AND in English goes inside the main function which in this case is SI or IF in English
Then your formula should look like this
=SI(Y(C6>=80, D6>=50), 2000, 0)
Since we are going to put a double comparison within the SI , then we separate them only by a comma
Consider it valid to answer you because you have in your question the idea of what the comparison in pseudocode would look like