excel

%3CLINGO-SUB%20id%3D%22lingo-sub-659744%22%20slang%3D%22en-US%22%3Eexcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-659744%22%20slang%3D%22en-US%22%3E%3CP%3Ecomo%20escribo%20una%20funci%C3%B3n%20de%20si%20(condici%C3%B3n)%20que%20diga%3C%2FP%3E%3CUL%3E%3CLI%3Eque%20si%20esta%20entre%200%20y%2095%20me%20de%200%25%3C%2FLI%3E%3CLI%3Eque%20si%20esta%20entre%2096%20y%20150%20me%20de%2019%25%3C%2FLI%3E%3CLI%3Eque%20si%20esta%20entre%20151%20y%20360%20me%20de%2028%25%3C%2FLI%3E%3CLI%3Eque%20si%20esta%20entre%20360%20e%20infinito%20me%20de%2033%25%3C%2FLI%3E%3C%2FUL%3E%3CP%3EGracias%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-659744%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-659867%22%20slang%3D%22en-US%22%3ERe%3A%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-659867%22%20slang%3D%22en-US%22%3E%3CP%3EHola%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F352340%22%20target%3D%22_blank%22%3E%40dilan2360%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESi%20est%C3%A1%20utilizando%20Office%20365%2C%20puede%20usar%20IFS%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D%20IFS%20(AND%20(A1%26gt%3B%20%3D%200%2C%20A1%20%26lt%3B%3D%2095)%2C%200%2C%20AND%20(A1%26gt%3B%20%3D%2096%2C%20A1%20%26lt%3B%3D%20150)%2C%2019%2C%20AND%20(A1%26gt%3B%20%3D%20151%2C%20A1%20%26lt%3B360)%2C%2028%2C%20A1%26gt%3B%20%3D%20360%2C%2033)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESi%20no%20est%C3%A1%20utilizando%20Office%20365%2C%20podr%C3%ADa%20usar%20IF%20anidado.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%C2%BFD%C3%A9jame%20saber%20c%C3%B3mo%20vas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAclamaciones%3CBR%20%2F%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E
dilan2360
Occasional Visitor

como escribo una función de si (condición) que diga

  • que si esta entre 0 y 95 me de 0%
  • que si esta entre 96 y 150 me de 19%
  • que si esta entre 151 y 360 me de 28%
  • que si esta entre 360 e infinito me de 33%

Gracias

1 Reply

Hola @dilan2360 

 

Si está utilizando Office 365, puede usar IFS:

 

= IFS (AND (A1> = 0, A1 <= 95), 0, AND (A1> = 96, A1 <= 150), 19, AND (A1> = 151, A1 <360), 28, A1> = 360, 33)

 

Si no está utilizando Office 365, podría usar IF anidado.

 

¿Déjame saber cómo vas?

 

Aclamaciones
Damien