Home

como hacer que se ponga cierta palabra dependiendo del valor de una celda

%3CLINGO-SUB%20id%3D%22lingo-sub-751256%22%20slang%3D%22es-ES%22%3Ehow%20to%20make%20it%20get%20a%20certain%20word%20depending%20on%20the%20value%20of%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-751256%22%20slang%3D%22es-ES%22%3E%3CP%3EHello%20good%20afternoon%2C%20I%20want%20to%20know%20how%20to%20get%20a%20certain%20label%20or%20word%20in%20excel%20depending%20on%20the%20value%20of%20a%20cell-%3C%2FP%3E%3CP%3EI%20want%20if%20the%20valos%20is%20more%20seventy%20and%20less%20than%20seventy-nine%20it%20gets%20%22acceptable%22%2C%20if%20it%20is%20within%20the%20range%20of%20eighty-eighty-nine%2C%20it%20gets%20%22good%22%2C%20from%2090%20to%2099%20it%20gets%20%22very%20good%22%20and%20if%20it%20is%20equal%20to%20100%20it%20gets%20%22excellent%22-%3C%2FP%3E%3CP%3EI%20try%20it%20with%20loggia%20function%20if%20nested%2C%20but%20it%20doesn't%20work%20for%20me%20and%20I%20don't%20know%20why%3C%2FP%3E%3CP%3Eattachment%20a%20file%20as%20I%20do%2C%20I%20wish%20someone%20can%20explain%20to%20me%20why%20it%20doesn't%20work%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-751256%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-752928%22%20slang%3D%22en-US%22%3ERe%3A%20como%20hacer%20que%20se%20ponga%20cierta%20palabra%20dependiendo%20del%20valor%20de%20una%20celda%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-752928%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F375105%22%20target%3D%22_blank%22%3E%40acuario5000%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20such%20sample%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20754px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F123190iA1C1F0BE4E721FD7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIf%20you%20add%20helper%20range%20as%20in%20column%20F%20and%20G%20that%20could%20be%20first%20formula.%20Hardcoded%20variant%20-%20second%20one.%3C%2FP%3E%0A%3CP%3EFormulas%20are%20in%20English%20locale%2C%20if%20you%20open%20attached%20file%20they%20will%20be%20transformed%20into%20your%20one.%3C%2FP%3E%3C%2FLINGO-BODY%3E
acuario5000
Occasional Visitor

Hola buenas tardes, quiero saber como hacer que se ponga un determinado rotulo o palabra en excel dependiendo del valor de una celda-

quiero que si el valos es de mas setenta y menor que setenta y nueve se ponga "aceptable", si esta dentro del rango de ochenta ochenta y nueve, se ponga "bueno", de 90 a 99 se ponga "muy bueno" y si es igual a 100 se ponga "excelente"-

lo intente con función logia si anidada, pero no me funciona y no se porque

adjunto un archivo de como lo hago, ojala alguien me pueda explicar por que no funciona

gracias

1 Reply

@acuario5000 

For such sample

image.png

If you add helper range as in column F and G that could be first formula. Hardcoded variant - second one.

Formulas are in English locale, if you open attached file they will be transformed into your one.

Related Conversations