Thread
:
here goes another
View Single Post
#
2
Posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
Posts: 35,218
here goes another
Put this in C1:
=INT(A1/2)
and put this in B1:
=A1-C1
Joe wrote:
ok i need
A1 number entered = B1 and C1
C1 must end in .00
exp:
A1 / 2 = B1 C1
$10.50 = $5.50 $5.00
$10.80 = $5.80 $5.00
$20.45 $10.45 $10.00
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson