By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,225 Members | 1,434 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,225 IT Pros & Developers. It's quick & easy.

Dividing currency in half?

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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]

Nov 13 '05 #2

P: n/a
Excellent, thanks for the hint!!

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.