MrExcel Publishing
Your One Stop for Excel Tips & Solutions

split up currency value


Posted by admin on May 28, 2001 5:01 AM

Sum of £5.00p and £5.50 is £10.50, I wish to split the sum into two cells, to get the result in £10 in one cell and the 50p in the next cell


Posted by Dave Hawley on May 28, 2001 5:07 AM


Hi Admin

Supposing your 5.50 is in cell A1, use:
=ROUNDDOWN(A1,0) In cell B1.
Then in cell C1 use:
=A1-B1


Dave

OzGrid Business Applications

Posted by Dave Hawley on May 28, 2001 5:09 AM

Oops typo, make 5.50 into 10.50

OzGrid Business Applications

Posted by Aladin Akyurek on May 28, 2001 5:52 AM

Or...

if you're summing 2 currency values, say in A1 and B1, and want directly split the result:

In C1 enter: =INT(A1+B1)
In D1 enter: =A1+B1-C1

Format C1 and D1 as currency.

Aladin