Necesito una formula, alguien podrá ayudarme?

%3CLINGO-SUB%20id%3D%22lingo-sub-2850863%22%20slang%3D%22es-ES%22%3EI%20need%20a%20formula%2C%20can%20someone%20help%20me%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2850863%22%20slang%3D%22es-ES%22%3E%3CP%3EI%20need%20a%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20one%20column%20go%20hectares%2C%20from%201%20to%20700.%20And%20in%20another%20column%20I%20need%20a%20formula%20that%20will%20give%20me%20back.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20If%20the%20number%20of%20hectares%20is%20between%201%20to%20250%2C%20the%20formula%20has%20to%20return%20%2410000.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E-%20If%20the%20number%20of%20hectares%20is%20between%20251%20to%20400%2C%20the%20formula%20has%20to%20return%20%2420000.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E-%20If%20the%20number%20of%20hectares%20is%20between%20401%20to%20700%2C%20the%20formula%20has%20to%20return%20%2430000.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20if%20in%20the%20column%20hectares%20I%20have%20no%20loaded%20value%2C%20or%20there%20is%20a%20zero%2C%20let%20me%20return%20zero.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20do%2C%20could%20someone%20help%20me%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20now%20on%20thank%20you%20very%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2850863%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2850960%22%20slang%3D%22en-US%22%3ERe%3A%20Necesito%20una%20formula%2C%20alguien%20podr%C3%A1%20ayudarme%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2850960%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1186502%22%20target%3D%22_blank%22%3E%40Leandro3847%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(AND(D3%26gt%3B%3D1%2CD3%26lt%3B%3D250)%2C%22%2410000%22%2C%3C%2FP%3E%3CP%3EIF(AND(D3%26gt%3B%3D251%2CD3%26lt%3B%3D400)%2C%22%2420000%22%2C%3C%2FP%3E%3CP%3EIF(AND(D3%26gt%3B%3D401%2CD3%26lt%3B%3D700)%2C%22%2430000%22%2C%3C%2FP%3E%3CP%3EIF(OR(D3%3D0%2CD3%3D%22%22)%2C0))))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEnter%20your%20values%20in%20range%20D3%3AD80%20for%20example.%20Enter%20above%20formula%20in%20F3%20and%20copy%20down.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DLOOKUP(D3%2C%7B0.1.251.401.701%7D%2C%7B0.%22%2410000%22.%22%2420000%22.%22%2430000%22%7D)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlternatively%20you%20can%20enter%20lookup%20formula%20to%20return%20results.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2850997%22%20slang%3D%22es-ES%22%3ERe%3A%20I%20need%20a%20formula%2C%20can%20anyone%20help%20me%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2850997%22%20slang%3D%22es-ES%22%3EThank%20you%20very%20much%20for%20replying%20and%20your%20help.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20I%20put%20the%20formula%20like%20this%26lt%3B%3D250)%2C%22%2424019%22%2CSI(Y(D25%26gt%3B%3DSI(Y(D25%26gt%3B%3D1%2CD25%3D251%2CD25%3D401D25%26lt%3B%3D400)%2C%22%2431225%22%2CSI(Y(D25%26gt%3B%20%26lt%3B%3D700)%2C%22%2448800%22%2CSI(O(D3%3D0%2CD3%3D%22%22)%2C%200))))%20%3CBR%20%2F%3E%20and%20it%20gives%20me%20error!%20%3C%2FLINGO-BODY%3E
Occasional Contributor

Necesito una formula.

 

En una columna van hectáreas, de 1 a 700. Y en otra columna necesito una fórmula que me devuelva..

 

- Si el número de hectáreas es entre 1 a 250, la fórmula me tiene que devolver $10000.  

- Si el número de hectáreas es entre 251 a 400, la fórmula me tiene que devolver $20000.  

- Si el número de hectáreas es entre 401 a 700, la fórmula me tiene que devolver $30000.  

 

Y si en la columna hectáreas no tengo valor cargado, o hay un cero, que me devuelva cero.

 

Como hago, alguien podría ayudarme?

 

Desde ya muchísimas gracias!!

5 Replies

@Leandro3847 

=IF(AND(D3>=1,D3<=250),"$10000",

IF(AND(D3>=251,D3<=400),"$20000",

IF(AND(D3>=401,D3<=700),"$30000",

IF(OR(D3=0,D3=""),0))))

 

Enter your values in range D3:D80 for example. Enter above formula in F3 and copy down.

 

=LOOKUP(D3,{0.1.251.401.701},{0."$10000"."$20000"."$30000"})

 

Alternatively you can enter lookup formula to return results.

Mil gracias por responderme y su ayuda.

puse la formula así =SI(Y(D25>=1,D25<=250),"$24019",SI(Y(D25>=251,D25<=400),"$31225",SI(Y(D25>=401D25<=700),"$48800",SI(O(D3=0,D3=""), 0))))
y me da error!
perdón así...

=SI(Y(D25>=1,D25<=250),"$24019",SI(Y(D25>=251,D25<=400),"$31225",SI(Y(D25>=401D25<=700),"$48800",SI(O(D25=0,D25=""), 0))))

y me da error
perdón así...

=SI(Y(D25>=1,D25<=250),"$24019",SI(Y(D25>=251,D25<=400),"$31225",SI(Y(D25>=401D25<=700),"$48800",SI(O(D25=0,D25=""), 0))))

y me da error
Graciassssssssssssssssssss!!!!!!!!!!!!! Le debo la vida ja ja ja!!!! muy amable, cuanto le agradezco!!!
Pude lograrlo!!