Forum Discussion
Solved
Can someone please explain how B9 is calculating this answer [Formula is (=SUM(B4-(B5:B8))]?
Priyanshu1325 That would be 1000-100 + 1000-150 + 1000-300 + 1000-100 = 3350
8 Replies
But won't this violate order of operations? How does excel read/interpret (B5:B9)?
Priyanshu1325 That would be 1000-100 + 1000-150 + 1000-300 + 1000-100 = 3350
Thank you very much. This was very helpful. Then how would I go about subtracting these cells? Is there any way to subtract like we add by just writing the first and last cell (eg. =SUM(B5:B9)?
