basic calculation yields different result depending on method- help?!

[BSWJON]

Hi folks,

I am using pivot tables to create calculated fields.

The arithmetic is: data1+data2+data3*100000/hours worked

If doing the calculation as above it yields a different value to manually adding the data figs and entering a number, ie

2*100000/hours worked

Then if i do other variations of essentially the same numbers, I get other different values (see below)

Can anyone explain why the numbers are different and which I should be using?

Apologies if this is basic maths (got me thinking back to BODMAS but surely Excel should factor this in?) but believe it or not, maths is not my forte!

Thanks as always

Jon

BSW Group HSMS Report 1.4.xlsm
	A	B	C	D	E	F	G	H
1	Site	Date	Fiscal Year	Total Hours Worked	Dat 1	Dat 2	Ignore	Dat 3
2	A	31/03/2022	2022	35592	0	0	0	0
3	B	31/03/2022	2022	26525	0	0	0	0
4	C	31/03/2022	2022	33842	0	0	0	0
5	D	31/03/2022	2022	8325	0	1	2	0
6	E	31/03/2022	2022	5519	0	0	0	0
7	F	31/03/2022	2022	19172	0	0	0	0
8	G	31/03/2022	2022	3617	0	0	0	1
9	H	31/03/2022	2022	34200	0	0	31	0
10				166792	0	1		1
11
12
13				Option 1	1.20
14				Option 2	1.60
15				Option 3	2.0
16				Option 4	0.60
Sheet13

Cell Formulas
Range	Formula
D10	D10	=SUBTOTAL(109,[Total Hours Worked])
E10	E10	=SUBTOTAL(109,[Dat 1])
F10	F10	=SUBTOTAL(109,[Dat 2])
H10	H10	=SUBTOTAL(109,[[Dat 3 ]])
E13	E13	=2*100000/Table18[[#Totals],[Total Hours Worked]]
E14	E14	=Table18[[#Totals],[Dat 1]]+Table18[[#Totals],[Dat 2]]+Table18[[#Totals],[Dat 3 ]]*100000/Table18[[#Totals],[Total Hours Worked]]
E15	E15	=1+1+0*100000/Table18[[#Totals],[Total Hours Worked]]
E16	E16	=0+0+1*100000/Table18[[#Totals],[Total Hours Worked]]

 

[RoryA]

It is BODMAS (or whatever acronym you prefer).

1+1+1/2 is not at all the same as (1+1+1)/2

 

[BSWJON]

Thanks Rory, yes upon further investigation, addition of brackets to the calculations eventually yields consistent results.

BSW Group HSMS Report 1.4.xlsm
	D	E
13	Option 1	1.199
14	Option 2	1.199
15	Option 3	1.199
16	Option 4	1.199
Sheet13

Cell Formulas
Range	Formula
E13	E13	=(2*100000)/Table18[[#Totals],[Total Hours Worked]]
E14	E14	=(Table18[[#Totals],[Dat 1]]+Table18[[#Totals],[Dat 2]]+Table18[[#Totals],[Dat 3 ]])*100000/Table18[[#Totals],[Total Hours Worked]]
E15	E15	=((1+1+0)*100000)/Table18[[#Totals],[Total Hours Worked]]
E16	E16	=((0+1+1)*100000)/Table18[[#Totals],[Total Hours Worked]]