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
Highlighted
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
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies