Forum Discussion
How can i resolve this problem?
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.)
Result also depends on version of Excel. IMHO, most correct formula will be
=20*SUM($B$5:$B$6)+$B$7
6 Replies
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.
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.
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!)
Result also depends on version of Excel. IMHO, most correct formula will be
=20*SUM($B$5:$B$6)+$B$7
