Calculation just doesnt add up

[ipbr21054]

Hi,
I am trying to write a small basic code for fuel allowance of 45p per mile.

Currently i use this which works fine & correct.

=E18*0.45

But i now wish to add the cell value at E34
So i have written,

=E18+E34*0.45

The value comes back as £256 but it should be £134.65

222 x 0.45P = £99.90
77 x 0.45P = £34.65
...................................
299 x 0.45p = £134.55

How did i write it incorrect,please advise thanks

 

[Fluff]

You need to put brackets around the addition.
Multiplication is done first followed by addition.

 

[Joe4]

In mathematics, the order of precedence perform multiplication BEFORE addition.
So to do what you want, use parentheses, i.e.

=(E18+E34)*0.45

 

[ipbr21054]

I knew that but been a long day BODMAS

Thanks

 

[Fluff]

Glad we could help & thanks for the feedback