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
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies
runtime error 1004 : Method range of object - 'Global' failed
Lorenzo Kim in Excel on
16 Replies
INDEX & MATCH interrupted by Inconsistent Dates
shade206 in Excel on
18 Replies
Need to extract values from named cells (Get and Transform)
JEMagnussen in Excel on
23 Replies
Creating tables and linking data
Sukhayanti in Excel on
10 Replies