View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe Joe is offline
external usenet poster
 
Posts: 476
Default here goes another

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