My totals in some cells differ from the same calculation done on a calculator even on the calculator on the computer. You probably all heard this one before but round up does not make a difference to the outcome.

Please show us your formula and your calculator result.

Could be me that's wrong lol

Attached Files

SUM UP WRONG.xlsm (12.3 KB, 18 views)

I can't replicate your calculator result.

With Windows calculator:
=B1*B2*B3 = B1*B2*(D2^2+D5^2)^(1/2)
=2000*6*(4+25)^(1/2)
=2000*6*29^(1/2)
=2000*6*5.3851648 = 64621.9776 (=B4)

=B4/B7 =64621.9776/40 = 1615.54944

XOR thanks for your reply I was correct I think it was me lol. I was doing the sum up on the bare figures present on the sheet missing out the=SQRT(SUMSQ(D2,D5)) on the calculator. I was just adding on the calculator 2000kg x 6.00m x 5.39m = A and also 5.00m x 8.00m =B Then dividing A with B However as you can see if I do this with the row on the right the figure comes out correct without putting SQRT(SUMSQ(D2,D5)) in the calculator why is this ? or am I doing something wrong as the formula should work without the equation SQRT(SUMSQ(D2,D5))

I am not sure what you mean.

2000*2*D3
= 2000*2*(6^2+5^2)^(1/2)
=2000*2*(36+25)^(1/2)
= 2000*2*61^(1/2)
=2000*2*7.810249675906...
=31240.99870362662
which divided by 40 gives:
781.0249675906654

look at the sheet do the sum up with the information displayed following the formula on the calculator the left row comes up different to the calculator but the right row correct with its present values change them and it don't match calculator why ? Can it be the PI in one of the equations but what is correct excel or calculator

Still I don't understand what you are talking about.
To me there is no difference between calculator result and Excel result.
Of course you can't in one situation calculate 2000*6*5.39 (with last factor rounded to two decimals) and in another situation calculate as you do in the Excel file (2000*6* last factor equal to 5,3851648071345) and get the same result.
Don't see PI anywhere in your calculations.
I will stop here.

Thanks for that

Sometimes as an expert in a field you sometimes have to take fifteen steps back to where you were a long time ago. This helps you understand where people are in their understanding of the subject which to you is easy and you then become frustrated as they don't come across in the same language. It would be like me taking the attitude if you do not make sense to me I will stop communication with you as you are not making any sense in my field. I take the time in my field if any one asks me a question which sounds silly to me I don't ridicule or disconnect from the conversation. I can use Excel to a point I do not use it every minute of the day and some things learned I have forgotten. A calculator to me sums up and as I said the left sums up wrong the right correct can you explain to me why this is as this forum is for people seeking help assistance. It may sound silly to you but the left sums up wrong but the right with the figures present Sums up correct on all calculators even on my pen and paper why is this

And my Pi claim is ongoing

Only joking thanks for taking the time to try and help

Regards

Sum UP

You are right, I became frustrated as I found that you did not care to help me when I expressed my doubt in post 07-26-2016 8:44 PM.

I am sure it is completely obvious to yourself what you mean, but not to me. This may partly be due to the fact that English is not my mother tongue. But it may also be due to inexact description of the problem! You could have done as I did namely showing exact spreadsheet/calculator examples and thus prevent any need for guesswork.

I have no desire at all to ridicule anyone (and have never been accused of that after more thousands posts) but neither I want to make guesses as to what a questioner mean.

Your problem may be a rounding issue (I'm not sure) so I give a link to one of many, many articles on that subject:

https://support.microsoft.com/en-us/kb/42980

Be warned however that floating point mathematics is a huge subject.

You also might consider to ask your question again in a new thread and then hopefully someone else will step in to help you. That actually was my way of thinking when I wrote: I will stop here.

Finally - your PI comment may be a joke, who knows, but it actually confused me which again may be due to my lack of knowledge of the finer nuances of the English language. And by the way - I have never and will never claim myself as an expert. You may be referring to the fact that on this site I am called 'Competent Performer', but I have had absolutely no influence on that. I am just an ordinary Excel user who now and then tries to help other Excel users.

Thank you very much for taking the time to help

XOR Just to let you know that you are a genius and should be upgraded to professional. I did as you said. The Maths need to be in the hundreds and thousands eg rather than 4.5 MTR it has to be 450.00 cm or lower. The input for the user would be 4.5 MTR but the calculations in the background must be in the smaller ratio. Just add a round up or round down depending in the side of safety you require and hey presto correct SUM up brilliant consider this solved but I cant mark it as solved as it wont let me or is it just me

Marked solved

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post