Sign Up ›
  • Colleen Burnsed 8
  • NEWBIE
  • 0 Points
  • Member since 2017
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 5
    Replies
12 replies

Rounding numbers up to the next quarter increment

I have a summed value of 5.57, i want this value to be 5.75 (the next rounded quarter). If I try ROUND(5.57+.124, 2) this returns 5.69 not 5.75. What am I missing?
12 replies

Rounding numbers up to the next quarter increment

I have a summed value of 5.57, i want this value to be 5.75 (the next rounded quarter). If I try ROUND(5.57+.124, 2) this returns 5.69 not 5.75. What am I missing?