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

This would be a formula for a ending balance in cell F3.

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

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Joey" wrote in message
...
This would be a formula for a ending balance in cell F3.

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

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.

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Joey" wrote in message
...
This would be a formula for a ending balance in cell F3.

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

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.

"Joey" wrote in message
...
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.

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Joey" wrote in message
...
This would be a formula for a ending balance in cell F3.

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

Thats It, Thank You.

"Fred Smith" wrote:

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.

"Joey" wrote in message
...
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.

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Joey" wrote in message
...
This would be a formula for a ending balance in cell F3.

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

Glad I could help. Thanks for the feedback.

Regards,
Fred.

"Joey" wrote in message
...
Thats It, Thank You.

"Fred Smith" wrote:

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.

"Joey" wrote in message
...
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.

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Joey" wrote in message
...
This would be a formula for a ending balance in cell F3.