View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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