Jan 21 2021 04:02 AM
tengo problemas con esta formula a que se debe:: =SI(G2="No" y(H2="yes");"naranjo";si(G2="Yes" y(H2="No");"verde";amarillo"))
Jan 21 2021 04:38 AM
Perhaps it shall be
= SI( (G2="No")*(H2="yes");"orange";SI( (G2="Yes")*(H2="No");"green";"yellow"))
(not tested)
Jan 21 2021 04:39 AM
Y is a function in Excel:
=SI(Y(G2="No";H2="Yes");"naranjo";SI(Y(G2="Yes";H2="No");"verde";amarillo"))