Discussion A complex formula that uses its own calculations in Excel
https://techcommunity.microsoft.com/t5/excel/a-complex-formula-that-uses-its-own-calculations/m-p/3006905#M123839
<P>A complex formula that uses its own calculations<BR />Hello<BR />They gave a task at work to calculate employee bonuses<BR />Handled it manually<BR />But perhaps it can be done with a formula?<BR />There is an amount, say - 100 dollars<BR />This is the basic premium<BR />It is issued if the turner has turned a thousand parts.<BR />There are multiplying coefficients<BR />For example<BR />Turner Sem turned 9300 parts<BR />The formula should do this:<BR />9300-1000 = 8300 (per cell)<BR />For the first thousand parts, a premium of 100 (in a separate cell)<BR />8300-1000 = 7300<BR />For the second thousand parts coefficient 1.1<BR />means 100 * 1.1 = 110 premium - in a separate cell<BR />Further<BR />7300-1000, odds for the third thousand 1, 2<BR />Etc<BR />Over the last 300 parts, premium 0.3<BR />(that is, if 1000 parts are not available, increasing coefficients are not applied, and the calculation is based on the base premium)<BR />After that, the formula adds up what she entered in the cells and gives out the amount of the bonus<BR />Is it possible to do this GENERALLY?<BR />Is it possible to formulate such a formula at all?<BR />thanks<BR />Alexey</P>Thu, 25 Nov 2021 21:20:45 GMTAlekseyKugno2021-11-25T21:20:45ZA complex formula that uses its own calculations
https://techcommunity.microsoft.com/t5/excel/a-complex-formula-that-uses-its-own-calculations/m-p/3006905#M123839
<P>A complex formula that uses its own calculations<BR />Hello<BR />They gave a task at work to calculate employee bonuses<BR />Handled it manually<BR />But perhaps it can be done with a formula?<BR />There is an amount, say - 100 dollars<BR />This is the basic premium<BR />It is issued if the turner has turned a thousand parts.<BR />There are multiplying coefficients<BR />For example<BR />Turner Sem turned 9300 parts<BR />The formula should do this:<BR />9300-1000 = 8300 (per cell)<BR />For the first thousand parts, a premium of 100 (in a separate cell)<BR />8300-1000 = 7300<BR />For the second thousand parts coefficient 1.1<BR />means 100 * 1.1 = 110 premium - in a separate cell<BR />Further<BR />7300-1000, odds for the third thousand 1, 2<BR />Etc<BR />Over the last 300 parts, premium 0.3<BR />(that is, if 1000 parts are not available, increasing coefficients are not applied, and the calculation is based on the base premium)<BR />After that, the formula adds up what she entered in the cells and gives out the amount of the bonus<BR />Is it possible to do this GENERALLY?<BR />Is it possible to formulate such a formula at all?<BR />thanks<BR />Alexey</P>Thu, 25 Nov 2021 21:20:45 GMThttps://techcommunity.microsoft.com/t5/excel/a-complex-formula-that-uses-its-own-calculations/m-p/3006905#M123839AlekseyKugno2021-11-25T21:20:45ZRe: A complex formula that uses its own calculations
https://techcommunity.microsoft.com/t5/excel/a-complex-formula-that-uses-its-own-calculations/m-p/3007086#M123843
<P><LI-USER uid="698525"></LI-USER> </P>
<P>See the attached sample workbook.</P>Thu, 25 Nov 2021 22:35:26 GMThttps://techcommunity.microsoft.com/t5/excel/a-complex-formula-that-uses-its-own-calculations/m-p/3007086#M123843Hans Vogelaar2021-11-25T22:35:26ZRe: A complex formula that uses its own calculations
https://techcommunity.microsoft.com/t5/excel/a-complex-formula-that-uses-its-own-calculations/m-p/3026359#M124513
<P><LI-USER uid="127945"></LI-USER></P><P> Thank you very much - you are a real Master<BR />my version is much more primitive and worse))))</P>Thu, 02 Dec 2021 08:53:32 GMThttps://techcommunity.microsoft.com/t5/excel/a-complex-formula-that-uses-its-own-calculations/m-p/3026359#M124513AlekseyKugno2021-12-02T08:53:32Z