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
AppSheet does not have MROUND() but I believe we could attempt to achieve the desired result similar to MROUND() using available AppSheet functions if you could share what you are exactly looking for using MROUND()
I mean MROUND() has syntax of MROUND(value , factor). May we know what factor you are trying to use in MAROUND()
1 Like
Perhaps some use of MOD() combined with something else… 
MOD() returns remainder after the division. I think the problem requires the Quotient. It doesn’t appear AppSheet has a Quotient function. However, I think you may be able to take advantage of the FLOOR() functions which will always round down - equivalent to truncating.
I BELIEVE the function that will work is (needs tested):
FLOOR([value] / [factor]) * [factor]
2 Likes
Factor is 0.25& Value is column value…
MROUND([COLUMN],0.25),this is exactly Needed.
Mround Work concept
Almost
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
5 Likes
Oh Great.This Formula Is Working Correctly…Thank You Very Much
1 Like