Related:

- I am just learning the basics
- Basic networking commands pdf - How-To - Network
- Explain spreadsheet and its basics - Articles
- Lava basic phone reset code ✓ - Forum - Mobile
- Basic concepts in photography - How-To - Multimedia
- Three basic types of network - Articles

## 6 replies

Blocked Profile

Give this a try. Instead of dividing the sum, multiply it by .5. same thing...

=(A1-B1-C1-D1-E1-F1-G1)*0.5+G2*2

=(A1-B1-C1-D1-E1-F1-G1)*0.5+G2*2

itstubtime

- Posts
- 6
- Registration date
- Wednesday August 7, 2013
- Status
- Member
- Last seen
- August 10, 2013

Thank You for the Quick reply.

The formula result is not giving the right result. the correct result should be 22 not 22.2. Any other Ideas?

Thank You

David

The formula result is not giving the right result. the correct result should be 22 not 22.2. Any other Ideas?

Thank You

David

Blocked Profile

Ah, yea. that is correct.

How do you get a whole number when clearly in your last cell there is a partial value of a number or .5. for 21.5.

So how do you get a whole number from a fraction, you round. Your worksheet (Cells) is(are) rounding.

Have fun!

How do you get a whole number when clearly in your last cell there is a partial value of a number or .5. for 21.5.

So how do you get a whole number from a fraction, you round. Your worksheet (Cells) is(are) rounding.

Have fun!

Blocked Profile

Yuu get the same result with this formula:

=A1-SUM(B1,C1,D1,E1,F1)

If you are subtracting F1 in your calculation, then remove it if it doesn't need to be part of the solution. (per your original question)...

PLease try to use my examples and LEARN FROM THEM BY LOOKING AT HOW IT WORKS, AND MODIFY to your own, need! DO NOT JUST TAKE MY ANSWER AND CUT AND PASTE IT! I am not doing anyones homework for them!

You say that you are just beginning with excel, but general "RULES" of Math says the "whole number" calculation is WRONG!

Go back and take a look at your math, and try it in your head 30(a1) minus 1(b1)=29, then minus 5(c1) for 24, minus 1(d1) for 23, minus 1(e1) for 22, minus .5(f1) = 21.5

If for some reason you do not want F1 in there then remove it...the point of the whole lesson was to reverse the Math Function and it will work.

BTW-you posted this in your question:

*******

=(J1/2)+(G2*2) this is now the right result of 11.5.

*****

Well, what value is G2? What ever is that cell will change the final answer.

Think about it once again, is it really wrong? No, the formula is, as I put F1 in place, when your question clearly DID not ask for F1, but I, once again, I am trying to teach you to use your brain, not cut and paste!

=A1-SUM(B1,C1,D1,E1,F1)

If you are subtracting F1 in your calculation, then remove it if it doesn't need to be part of the solution. (per your original question)...

PLease try to use my examples and LEARN FROM THEM BY LOOKING AT HOW IT WORKS, AND MODIFY to your own, need! DO NOT JUST TAKE MY ANSWER AND CUT AND PASTE IT! I am not doing anyones homework for them!

You say that you are just beginning with excel, but general "RULES" of Math says the "whole number" calculation is WRONG!

Go back and take a look at your math, and try it in your head 30(a1) minus 1(b1)=29, then minus 5(c1) for 24, minus 1(d1) for 23, minus 1(e1) for 22, minus .5(f1) = 21.5

If for some reason you do not want F1 in there then remove it...the point of the whole lesson was to reverse the Math Function and it will work.

BTW-you posted this in your question:

*******

=(J1/2)+(G2*2) this is now the right result of 11.5.

*****

Well, what value is G2? What ever is that cell will change the final answer.

Think about it once again, is it really wrong? No, the formula is, as I put F1 in place, when your question clearly DID not ask for F1, but I, once again, I am trying to teach you to use your brain, not cut and paste!

itstubtime

- Posts
- 6
- Registration date
- Wednesday August 7, 2013
- Status
- Member
- Last seen
- August 10, 2013

Thanks for the reply.

What I was doing was opening a new sheet and calling it test sheet and trying the formula multiple ways.

I did not know you could cut and paste an answer. in my learning process i was wanting to get use to the key strokes not cut and paste. the simple answer was not what I was looking for. an explanation of what the formula was saying or how it should be said was what i was looking for. for example A1 minus B1 Minus and so on,I just did not know how to add then divide by 2 to the formula to get it to work.

What I was doing was opening a new sheet and calling it test sheet and trying the formula multiple ways.

I did not know you could cut and paste an answer. in my learning process i was wanting to get use to the key strokes not cut and paste. the simple answer was not what I was looking for. an explanation of what the formula was saying or how it should be said was what i was looking for. for example A1 minus B1 Minus and so on,I just did not know how to add then divide by 2 to the formula to get it to work.

itstubtime

- Posts
- 6
- Registration date
- Wednesday August 7, 2013
- Status
- Member
- Last seen
- August 10, 2013

i still haven't figured it out yet.

just a little confused by the answer.

David

just a little confused by the answer.

David

Blocked Profile

Okey dokey, take your time. It is much easier to multiply by .5 than it is to divide by 2. SO in your formula to divide, just change it to multiply by .5 (same thing).

=(A1-B1-C1-D1-E1-F1)*0.5+G2*2 will give you what you are looking for, I have removed the G1 reference placed in my earlier answer-bringing OUR totals to the same number (22).

=(A1-B1-C1-D1-E1-F1)*0.5+G2*2 will give you what you are looking for, I have removed the G1 reference placed in my earlier answer-bringing OUR totals to the same number (22).

- Posts
- 6
- Registration date
- Wednesday August 7, 2013
- Status
- Member
- Last seen
- August 10, 2013

Thank You Again

I was understanding the multiply instead of divide.

on the test sheet i still had the other column J in the equation

I did it all again on another and it worked.

Thank You For your time and Patience.

Now I will work on combining 4 sheets to 1 sheet.

Thank You David

I was understanding the multiply instead of divide.

on the test sheet i still had the other column J in the equation

I did it all again on another and it worked.

Thank You For your time and Patience.

Now I will work on combining 4 sheets to 1 sheet.

Thank You David