On 2 Nov 2005 06:29:38 -0800, "Chris" <cs*******@yahoo.co.uk> wrote:

Hi all,

I'm wanting to divide a currency total in half but can't think of a way

of doing it. The idea is to split a profit text box in two therefore

showing 2 amounts which add up to the total profit box. Thing is I

can't work out how to split an odd currency amount, so that one of the

two (smaller) amounts is 1 penny different so as to add up to exactly

the right total profit.

I hope that all makes sense?

Thanks in advance!

Chris

Something like this, perhaps?

txtPartial1: =Round(Sum([value])*CCur(.5), 2)

txtPartial2: =Sum([value]) - [txtPartial1]