Same formula one not calculating properly?

  • Thread starter Thread starter ss
  • Start date Start date
S

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
 
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
Click to expand...

(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.
 
(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.
Click to expand...

Thanks Alex I see where I have gone wrong.

thank you
 
Back
Top