Solved: Any Equivalent For Mround up in Appsheet? - Page 2

BHUVANESH · 08-27-2022 12:04 AM

MRounud(sheet formula) is

=MROUND(253.5,0.25)

I have Column value Needed Based On the Mround Up formula For appsheet

Any Equivalent For Mround up in Appsheet..

Thanks in advance

SkrOYC

Almost

@WillowMobileSys wrote:
FLOOR([value] / [factor]) * [factor]

Use ROUND() instead of FLOOR()

ROUND([Value]/[Factor])*[Factor]

Taking these examples:

ROUND(10/3) = ROUND(3.33333) = 3;
3 * 3 = 9

ROUND(-10/-3) = ROUND (3.33333) = 3;
3 * -3 = -9

ROUND(1.3/0.2) = ROUND(6.5) = 7;
7 * 0.2 = 1.4