May 29 2020 10:03 AM
=SI(C28<=65%;"No Satisfactorio";SI(Y(C28>65%;C28<90%);"Satisfactorio";SI(C28>=90%;"Sobresaliente")))
me devuelve mal cuando el valor es igual a 90%????
May 31 2020 07:15 PM
@jorhumlojar I hope you have new IFS function available in Excel to avoid nested IFs:
IFS(C28<=0.65,"No satisfactorio",C28<0.90,"Satisfactorio",TRUE,"Outstanding")
If not:
IF(C28<=0.65,"No satisfactorio",IF(C28<0.90,"Satisfactorio","Outstanding"))