pounds and pisters

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

YaSso - 19 May 2008 14:41 GMT

i want to make separated cells for pounds and pisters and sum the total of
them.If pisters more than or equal 100 pisters, the integers automatically
add to the sum of pounds.

Reply to this Message

edvwvw - 19 May 2008 15:39 GMT

>i want to make separated cells for pounds and pisters and sum the total of
>them.If pisters more than or equal 100 pisters, the integers automatically
>add to the sum of pounds.

If your Pounds are in Column A and pisters (I am not familiar with that
currency) in Column B
use the following formula:

=(SUM(A1:A6))+(SUM(B1:B6)/100)

This will give pounds.pisters

edvwvw

Reply to this Message

YaSso - 19 May 2008 19:13 GMT

thank u for ur help but acctually i want the tolal of pisters below cells in
column B and the the total of pounds below cells in column A,

> >i want to make separated cells for pounds and pisters and sum the total of
> >them.If pisters more than or equal 100 pisters, the integers automatically
[quoted text clipped - 9 lines]
>
> edvwvw

Reply to this Message

David Biddulph - 19 May 2008 19:37 GMT

=SUM(A1:A6)+INT(SUM(B1:B6)/100) for A
=MOD(SUM(B1:B6),100) for B
--
David Biddulph

> thank u for ur help but acctually i want the tolal of pisters below cells
> in
[quoted text clipped - 15 lines]
>>
>> edvwvw

Reply to this Message

Gord Dibben - 20 May 2008 00:58 GMT

I'm betting on "piasters" or "piastres"

Gord Dibben MS Excel MVP

>and pisters (I am not familiar with that
>currency) in Column B

Reply to this Message