Thread: Formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marvin Marvin is offline
external usenet poster
 
Posts: 71
Default Formulas

how do i create a formula to divide a number by 2 and then display it to the
nearest 5

99 divided 2 = 49.5 and then have the display read 45

or

74 divided by 2 = 37 and then display 35