SOLVED

How can i resolve this problem?

%3CLINGO-SUB%20id%3D%22lingo-sub-1356054%22%20slang%3D%22en-US%22%3EHow%20can%20i%20resolve%20this%20problem%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1356054%22%20slang%3D%22en-US%22%3E%3CP%3ESorry%20I%20don't%20know%20English%20(but%20I'll%20try).%20I%20have%20a%20problem%20with%20one%20calculation.%20Specifically%3A%20the%20same%20numbers%2C%20but%20the%20same%20function%2C%20but%20the%20result%20is%20different%20in%20both%20equivalent%20calculations.%20If%20only%20I%20knew%20what%20the%20correct%20function%20must%20be%20to%20get%20the%20right%20result%20(and%20it's%20the%20same%20number%20in%20both%20identical%20operations).%20Sending%20file%20(Microsoft%20Office%20Home%20and%20Student%202013).%20What's%20wrong%3F%20Can%20you%20tell%20me%20what's%20wrong%20and%20maybe%20send%20me%20back%20the%20right%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%223%22%3E(In%20Estonian%3A%26nbsp%3B%20%26nbsp%3B%3C%2FFONT%3E%C3%9Ches%20arvutuses%20on%20minul%20probleem.%20T%C3%A4psemalt%3A%20samad%20arvud%2C%20sama%20funktsioon%20aga%20tulemus%20on%20m%C3%B5lemas%20samav%C3%A4%C3%A4rses%20arvutuses%20erinev.%20Kui%20ma%20vaid%20teaks%2C%20milline%20peab%20olema%20%C3%B5ige%20funktsioon%2C%20et%20saada%20%C3%B5ige%20tulemus%20(ja%20see%20on%20sama%20arv%20m%C3%B5lemas%20%C3%BChesuguses%20tehtes).%20Saadan%20faili%20(Microsoft%20Office%20Home%20and%20Student%202013).%20Milles%20on%20viga%3F%20Kas%20%C3%BCtlete%2C%20milles%20on%20viga%20ja%20ehk%20saadate%20minule%20tagasi%20%C3%B5ige%20valemi.%3CFONT%20size%3D%223%22%3E)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1356054%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1356081%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20i%20resolve%20this%20problem%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1356081%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F645276%22%20target%3D%22_blank%22%3E%40MarekKoppel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUsing%20of%26nbsp%3B%20%22%3CSTRONG%3E%40%3C%2FSTRONG%3E%22%20means%20to%20return%20intersection%20of%20the%20B5%3AB6%20with%20current%20row.%20Thus%20it%20returns%2018%20if%20the%20formula%20is%20in%20any%20cell%20in%20row%20%235%2C%2026%20for%20row%20%236%20and%20error%20for%20any%20other%20row.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20381px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F188496i9EECE5194166C387%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThus%26nbsp%3B%3D%40%24B%245%3A%24B%246%20in%205th%20row%20is%20equivalent%20of%20%3DB5%2C%20etc.%3C%2FP%3E%0A%3CP%3ENot%20sure%20what%20you'd%20like%20to%20calculate%2C%20thus%20don't%20suggest%20any%20formula.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1356103%22%20slang%3D%22en-US%22%3ERe%3A%20Kuidas%20ma%20saan%20seda%20probleemi%20lahendada%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1356103%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20helping!%20I'm%20learning%20Excel%20and%20I%20already%20know%20it%20a%20bit.%20I%20am%20currently%20using%20the%20same%20operation%20on%20different%20samples%3A%3C%2FP%3E%3CP%3E%3D((B%245%3A%24B%246)*20)%2B%24B%247%26nbsp%3B%3C%2FP%3E%3CP%3E%3D((B5%3A%20B6)*20)%2BB7)%3C%2FP%3E%3CP%3E%3DSUM((%24B%245%3A%24B%246)*20)%2B%24B%247%3C%2FP%3E%3CP%3E%3DSUM((B5%3A%20B6)*20)%2BB7%3C%2FP%3E%3CP%3EBut%20different%20cells%20always%20have%20different%20values.%20But%20I%20always%20use%20the%20same%20bill.%3C%2FP%3E%3CP%3E(Sorry%20for%20my%20bad%20English!)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1356156%22%20slang%3D%22en-US%22%3ERe%3A%20Kuidas%20ma%20saan%20seda%20probleemi%20lahendada%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1356156%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F645276%22%20target%3D%22_blank%22%3E%40MarekKoppel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EResult%20also%20depends%20on%20version%20of%20Excel.%20IMHO%2C%20most%20correct%20formula%20will%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3D20*SUM(%24B%245%3A%24B%246)%2B%24B%247%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1356276%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20i%20resolve%20this%20problem%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1356276%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20form%20is%20working!%20Thanks%20to%20You%2C%20I%20can%20progress%20in%20learning%20Excel.%20My%20young%20children%20are%20now%20happy%20(I%20constantly%20communicate%20with%20them%20about%20my%20various%20jobs).%20I'm%20not%20saying%20%3CU%3EYou're%20a%20professional%3C%2FU%3E.%20Just%20say%20%3CU%3EI'm%20very%20stupid%20in%20Excel%3C%2FU%3E.%20Thank%20You%20(and%20the%20other%20people%20who%20support%20me%20in%20my%20studies)!%3C%2FP%3E%3CP%3E(Sorry%20for%20my%20bad%20English!)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1356327%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20i%20resolve%20this%20problem%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1356327%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F645276%22%20target%3D%22_blank%22%3E%40MarekKoppel%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome.%20Each%20of%20us%20do%20first%20steps%20in%20this%20or%20that%20area%2C%20that's%20normal.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1356427%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20i%20resolve%20this%20problem%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1356427%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20studied%2C%20researched%2C%20tried%2C%20made%20a%20mistake%2C%20looked%20at%20your%20formula%2C%20tried%20again%20and%20-%20thanks%20to%20You%2C%20I%20have%20the%20right%20answer%20at%20this%20level%20of%20study.%20The%20most%20correct%20operation%20is%20%3D(20*(SUM(%24B%245%3A%24B%246)%2B%24B%247)).%20I%20will%20send%20the%20best%20solution%20in%20the%20file%20%E2%80%9CThanks.xlsx%22.%20In%20addition%20to%20Your%20help%2C%20I%20was%20supported%20by%20my%20eight-year-old%20son.%20Thanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(Sorry%20for%20my%20bad%20English!)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Sorry I don't know English (but I'll try). I have a problem with one calculation. Specifically: the same numbers, but the same function, but the result is different in both equivalent calculations. If only I knew what the correct function must be to get the right result (and it's the same number in both identical operations). Sending file (Microsoft Office Home and Student 2013). What's wrong? Can you tell me what's wrong and maybe send me back the right formula.

 

 

(In Estonian:   Ühes arvutuses on minul probleem. Täpsemalt: samad arvud, sama funktsioon aga tulemus on mõlemas samaväärses arvutuses erinev. Kui ma vaid teaks, milline peab olema õige funktsioon, et saada õige tulemus (ja see on sama arv mõlemas ühesuguses tehtes). Saadan faili (Microsoft Office Home and Student 2013). Milles on viga? Kas ütlete, milles on viga ja ehk saadate minule tagasi õige valemi.)

6 Replies
Highlighted

@MarekKoppel 

Using of  "@" means to return intersection of the B5:B6 with current row. Thus it returns 18 if the formula is in any cell in row #5, 26 for row #6 and error for any other row.

image.png

Thus =@$B$5:$B$6 in 5th row is equivalent of =B5, etc.

Not sure what you'd like to calculate, thus don't suggest any formula.

  

Highlighted

@Sergei Baklan 

Thanks for helping! I'm learning Excel and I already know it a bit. I am currently using the same operation on different samples:

=((B$5:$B$6)*20)+$B$7 

=((B5: B6)*20)+B7)

=SUM(($B$5:$B$6)*20)+$B$7

=SUM((B5: B6)*20)+B7

But different cells always have different values. But I always use the same bill.

(Sorry for my bad English!)

Highlighted
Best Response confirmed by MarekKoppel (Occasional Contributor)
Solution

@MarekKoppel 

Result also depends on version of Excel. IMHO, most correct formula will be

=20*SUM($B$5:$B$6)+$B$7
Highlighted

@Sergei Baklan 

Your form is working! Thanks to You, I can progress in learning Excel. My young children are now happy (I constantly communicate with them about my various jobs). I'm not saying You're a professional. Just say I'm very stupid in Excel. Thank You (and the other people who support me in my studies)!

(Sorry for my bad English!)

Highlighted

@MarekKoppel , you are welcome. Each of us do first steps in this or that area, that's normal.

Highlighted

@Sergei Baklan 

I studied, researched, tried, made a mistake, looked at your formula, tried again and - thanks to You, I have the right answer at this level of study. The most correct operation is =(20*(SUM($B$5:$B$6)+$B$7)). I will send the best solution in the file “Thanks.xlsx". In addition to Your help, I was supported by my eight-year-old son. Thanks!

 

(Sorry for my bad English!)