help pence to pounds with formula

[ss]

I am using =(B3*D3)+(E3*C3)/100
the part /100 I thought would convert to £s
but is giving £1982 instead of £19.82
can you please correct.

thank you

 

[Claus Busch]

Hi,

Am Sun, 16 Jun 2013 19:08:09 +0100 schrieb ss:

I am using =(B3*D3)+(E3*C3)/100
the part /100 I thought would convert to £s
but is giving £1982 instead of £19.82
can you please correct.

try:
=(B3*D3+C3*E3)/100


Regards
Claus Busch

 

[ss]

Hi,

Am Sun, 16 Jun 2013 19:08:09 +0100 schrieb ss:


try:
=(B3*D3+C3*E3)/100


Regards
Claus Busch

Worked, thanks Claus