View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
JeriSys
 
Posts: n/a
Default What is the formula for rounding a dollar amount to the nearest ni

Didn't make sense... I meant cents rounding to nearest nickle,Example: 1.22 =
1.20 or 1.23 = 1.25. ;-)

"JeriSys" wrote:

What is the formula for rounding a dollar amount to the nearest nickel?