help pence to pounds with formula

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

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

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


Regards
Claus Busch
 
Back
Top