Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
help pence to pounds with formula
10 views
Skip to first unread message
ss
Jun 16, 2013, 2:08:09 PM6/16/13
to
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
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
Jun 16, 2013, 2:12:20 PM6/16/13
to
Hi,
try:
=(B3*D3+C3*E3)/100
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
=(B3*D3+C3*E3)/100
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
ss
Jun 16, 2013, 2:18:24 PM6/16/13
to
On 16/06/2013 19:12, Claus Busch wrote:
> 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
Worked, thanks Claus
> 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
0 new messages