Home

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
Highlighted

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
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies