View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe Joe is offline
external usenet poster
 
Posts: 476
Default ROUNDING AND 2 FORMUALS IN ONE CELL

how can i Divide numbers and have results in 2 different cells rounded to the
nearest .25 cent round one cell up and on cell down so it equals the total
like
10.25/2=5.25 AND 5.00 OR 10.75/2 =5.50 AMD 5.25