Same formula one not calculating properly?

[ss]

This is the two formulas I am using the structure is the same but with
different figures, why is one not working properly and giving an
incorrect answer?

(H18+H19)-(H20)*(100*0.05) Equates to (9+15)-(4)x(5%) returns £1 which
is correct

(B18+B19)-(B20)*(100*0.05) Equates to (44+15)-(4)x(5%) returns £59 but
should be £2.75

 

[Alex Plantema]

ss schreef in

This is the two formulas I am using the structure is the same but with
different figures, why is one not working properly and giving an
incorrect answer?

(H18+H19)-(H20)*(100*0.05) Equates to (9+15)-(4)x(5%) returns £1 which is correct

(B18+B19)-(B20)*(100*0.05) Equates to (44+15)-(4)x(5%) returns £59 but should be £2.75

(9+15)-(4)x(5%) returns 23.8 whereas ((9+15)-(4))x(5%) returns 1.
(44+15)-(4)x(5%) returns 58.8 whereas ((44+15)-(4))x(5%) returns 2.75.

 

[ss]

(9+15)-(4)x(5%) returns 23.8 whereas ((9+15)-(4))x(5%) returns 1.
(44+15)-(4)x(5%) returns 58.8 whereas ((44+15)-(4))x(5%) returns 2.75.

Thanks Alex I see where I have gone wrong.

thank you