View Single Post
  #1   Report Post  
Diane
 
Posts: n/a
Default rounding to nearest hundred dollar in Excel

User wants to round up to nearest $100 dollar figure if it's over 50, or down
to nearest $100 figure if it's under 50. For example, if they enter dollar
figure of $1234.00, they want it rounded down to the nearest $100 dollar
amount, which would be $1,200.00. Thanks.