View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JmyCrikitt JmyCrikitt is offline
external usenet poster
 
Posts: 3
Default Round to multiple of 5

I am having trouble with formula to round results to a multiple of 5

Current formula results return the following values and I want to round them
to the nearest multiple of .05

Current Desired
Result Result
$25.61 = $25.60
$25.83 = $25.85
$26.06 = $26.05
$26.28 = $26.30
$26.50 = $26.50
$26.72 =$ 26.70

Appreciate any help. Thank you