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.

YaSso wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200805/1

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,

"edvwvw via OfficeKB.com" wrote:

YaSso wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200805/1

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

"YaSso" wrote in message
...
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,

"edvwvw via OfficeKB.com" wrote:

YaSso wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200805/1

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


Gord Dibben MS Excel MVP

On Mon, 19 May 2008 14:39:46 GMT, "edvwvw via OfficeKB.com" <u42512@uwe wrote:

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