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

  • Thread starter Thread starter Joey
  • Start date Start date
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
 
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.
 
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.
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Time sheet template military hours problem 6
Please suggest any formulae / functions 2
Supress DIV/0 2
Formulas 3
SUMIF: How to add some cells and ignore other cells in a row 2
Copy formula - how to keep row the same but incrament the column 4
Can I freeze 3 different columns? 10

Back
Top