Hi all,
If in A1 I enter $1000.00 and in B1 I enter a share price of $14.00 Then in C1 I divide A1 by B1 It will return the number of shares I will get which is 71 in cell C1.
My problem is when in D1 I try to sum up C1 multiply by B1 ''=sum(C1*B1) the result I get is $1000.00 instead of $994.00. Anyone knows why?
Do I use the wrong formula?
Thank you for your help
If in A1 I enter $1000.00 and in B1 I enter a share price of $14.00 Then in C1 I divide A1 by B1 It will return the number of shares I will get which is 71 in cell C1.
My problem is when in D1 I try to sum up C1 multiply by B1 ''=sum(C1*B1) the result I get is $1000.00 instead of $994.00. Anyone knows why?
Do I use the wrong formula?
Thank you for your help