How would I enter this formula so it works. B3+C3-D3*E3 ?

B

Bernard Liengme

Being all formulas with =, so you need =B3+C3-D3*E3
But we aware the multiplication happens first, so it finds = (B3+C3) -
(D3*E3)
If you want to add the two values, do the subtraction and then multiply, use
=(B3+C3-D3)*E3
best wishes
PS Please write Question in the white space
PPS The formula is the same no matter what cell you put it in
 
J

Joey

Hi Mr. Liengme,
Thanks for the reply, I am working on a Retirement Calculator. B3 =starting
balance, C3 = annual contribution, D3 = withdrawal, E3 = return, F3= ending
balance. I cannot get excel to calculate and add, the return which is 10% to
the addition of cell B3,C3 and subtraction of D3. Of course the answer being
in cell F3.
 
F

Fred Smith

This information should have helped right from the beginning.

You want to take a starting balance, B3, subtract withdrawals, and add
deposits. That formula, as you would expect, is:
=B3+C3-D3

Now you want to add return on investment. If you simply multiply this total
by E3 (your rate of return), you are calculating the interest earned for the
year. But you want to add it to the original balance. So, do it this way:
=(B3+C3-D3)*(1+E3)

We'll refrain from commenting that your 10% return assumption is probably
over-optimistic.

Regards,
Fred.
 
J

Joey

Thats It, Thank You.

Fred Smith said:
This information should have helped right from the beginning.

You want to take a starting balance, B3, subtract withdrawals, and add
deposits. That formula, as you would expect, is:
=B3+C3-D3

Now you want to add return on investment. If you simply multiply this total
by E3 (your rate of return), you are calculating the interest earned for the
year. But you want to add it to the original balance. So, do it this way:
=(B3+C3-D3)*(1+E3)

We'll refrain from commenting that your 10% return assumption is probably
over-optimistic.

Regards,
Fred.
Click to expand...
 
Top