Forum Discussion

Yolanda Cardiff's avatar
Yolanda Cardiff
Copper Contributor
Jan 03, 2018

MROUND VS. FLOOR

Aloha I need to round to the next lower 5 the following numbers; 2100 (must be 2095) 1519 (must be 1515) 1393 (must be 1385) 1617 (must be 1615) Using MROUND works for some numbers, same with FLOOR, not all numbers change to the next lower 5 Someone can help, please!?

Formulas & Functions
Need Help

1 Reply

  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Jan 04, 2018

    Hi Yolanda Cardiff

     

    Maybe you could try this  (assuming your value to round is in A1

     

    =IF(  MOD(FLOOR(A1,5),10)=0,  FLOOR(A1-5,5),   FLOOR(A1,5)  )