Forum Discussion
How can i resolve this problem?
Result also depends on version of Excel. IMHO, most correct formula will be
=20*SUM($B$5:$B$6)+$B$7
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$7Your 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!)
MarekKoppel , you are welcome. Each of us do first steps in this or that area, that's normal.
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!)