pounds and pisters

[YaSso]

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.

 

[edvwvw via OfficeKB.com]

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

 

[YaSso]

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,

 

[David Biddulph]

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

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP