Formula to Calculate Shares

[NeoSez]

I am trying to calculate the amount of shares I can purchase using the formula below. However, when I use a calculator the amount of shares to buy is different from the excel shares to buy. What am I doing wrong with the formula? Thanks for your help.

=(A2*B2)-C2/D2

or

=A2*B2-C2/D2

Account Balance	% of Balance to Invest	COMMISSION	ASK PRICE	SHARES TO BUY

 

[etaf]

you may need a bracket
=(A2*B2)-(C2/D2)
=((A2*B2)-C2)/D2
Above will give different results

Excel carries out maths function in a certain order

1. Parentheses
2. Exponents
3. Multiplication and Division
4. Addition and Subtraction
5. Concatenation
6. Logical operators

The order in which Excel performs operations in formulas - Microsoft Support

In some cases, the order in which a calculation is performed can affect the return value of the formula, so it's important to understand how the order is determined and how you can change the order to obtain the results you want.

support.microsoft.com

 

[NeoSez]

you may need a bracket
=(A2*B2)-(C2/D2)
=((A2*B2)-C2)/D2
Above will give different results

Excel carries out maths function in a certain order

1. Parentheses
2. Exponents
3. Multiplication and Division
4. Addition and Subtraction
5. Concatenation
6. Logical operators

The order in which Excel performs operations in formulas - Microsoft Support

In some cases, the order in which a calculation is performed can affect the return value of the formula, so it's important to understand how the order is determined and how you can change the order to obtain the results you want.

support.microsoft.com

Thanks Etaf!
Funny how a ")" can make a difference.

 

[etaf]

you are welcome