SOLVED

como obtener la utilidad / costo de un producto?

%3CLINGO-SUB%20id%3D%22lingo-sub-3222941%22%20slang%3D%22es-ES%22%3Ehow%20to%20get%20the%20utility%2Fcost%20of%20a%20product%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3222941%22%20slang%3D%22es-ES%22%3E%3CP%3EGreetings%20to%20all.%20I%20cost%20a%20product%20in%2C%20say%2C%20100.00%20and%20add%20a%20certain%20profit%20margin%2C%20let's%20say%2025%25%2C%20I%20get%20as%20a%20result%20125.%20But%2C%20if%20I%20apply%20the%2025%25%20discount%20to%20125%20I%20get%2093.75%3B%20that%20is%2C%20below%20cost%20(100).%20I%20need%20to%20calculate%20the%20price%2C%20not%20with%20the%20formula%20(100*1.25%3D125)%2C%20but%20with%20(100*1.33333%3D133%2C333)%2C%20so%20that%20when%20applying%20the%20described%20discount%20I%20get%20100.%20How%20can%20I%20find%20that%20factor%20(1.333)%20with%20an%20Excel%20formula%3F.%20I%20appreciate%20your%20comments.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3222941%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3223129%22%20slang%3D%22en-US%22%3ERe%3A%20como%20obtener%20la%20utilidad%20%2F%20costo%20de%20un%20producto%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3223129%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1187812%22%20target%3D%22_blank%22%3E%40a7024782%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3D100%25%2F(100%25-25%25)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Saludos a todos. Costeo un producto en, digamos, 100,00 y le sumo un determinado margen de utilidad, digamos 25%, obtengo como resultado 125. Pero, si aplico el 25% de descuento a 125 obtengo 93,75; es decir por debajo del costo (100). Necesito calcular el precio, no con la formula (100*1.25=125), sino con (100*1.33333=133,333), para que al aplicar el descuento descrito obtenga 100. Como puedo hallar ese factor (1.333) con una formula de Excel?. Agradezco sus comentarios.

1 Reply
best response confirmed by a7024782 (Occasional Contributor)
Solution

@a7024782 

=100%/(100%-25%)