SI ALGUIEN ME PUEDE AYUDAR

%3CLINGO-SUB%20id%3D%22lingo-sub-1363864%22%20slang%3D%22es-ES%22%3EIF%20ANYONE%20CAN%20HELP%20ME%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1363864%22%20slang%3D%22es-ES%22%3E%3CP%3EI%20NEED%20HELP%20PLEASE.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20MUST%20PLACE%20A%20FUNCTION%20IN%20THE%20PENULTIMATE%20COLUMN%2C%20IT%20WORK%20WITH%20SUCCESSIVE%20CONDITIONALS%20NESTED%20IN%20SUCH%20A%20WAY%20THAT%20IT%20RETURNS%20THE%20VALUE%26nbsp%3B%3C%2FP%3E%3CP%3E1-%20IF%20THE%20REFERENCE%20OF%20THE%20ARTICLE%20STARTS%20BY%20hp%20RETURNS%20A%20PERCENTAGE%20OF%2080%25%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%220%22%20width%3D%22400%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2280%22%20height%3D%2217%22%3EReference%3C%2FTD%3E%3CTD%20width%3D%2280%22%3EName%3C%2FTD%3E%3CTD%20width%3D%2280%22%3EPurchase%20price%3C%2FTD%3E%3CTD%20width%3D%2280%22%3E%25%20of%20Benefit%3C%2FTD%3E%3CTD%20width%3D%2280%22%3ESale%20price%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2217%22%3Ehp8%3C%2FTD%3E%3CTD%3EMetal%20brush%3C%2FTD%3E%3CTD%3E1.1%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2217%22%3Ehp9%3C%2FTD%3E%3CTD%3ECarpenter%20brush%3C%2FTD%3E%3CTD%3E2.4%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2217%22%3Ehp10%3C%2FTD%3E%3CTD%3ESmall%20tongs%3C%2FTD%3E%3CTD%3E1.2%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2217%22%3Ehe1%3C%2FTD%3E%3CTD%3EElectric%20drill%20c%2Fc%3C%2FTD%3E%3CTD%3E24%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1363864%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3ECommunity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

NECESITO ME AYUDEN PORFAVOR.

 

DEBO COLOCAR UNA FUNCION EN LA PENULTIMA COLUMNA, FUNCION CON CONDICIONALES SUCESIVAS ANIDADAS DE TAL MANERA QUE DEVUELVA EL VALOR 

1- SI LA REFERENCIA DEL ARTICULO EMPIEZA POR hp DEVUELVE UN PORCENTAJE DE 80%

 

 

ReferenciaNombrePrecio compra% deBeneficioPrecio de venta
hp8Cepillo metálico1.1  
hp9Cepillo carpintero2.4  
hp10Tenazas pequeñas1.2  
he1Taladro eléctrico c/c24  
0 Replies