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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies