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
