Any Equivalent For Mround up in Appsheet?

[BHUVANESH]

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

[Suvrutt_Gurjar]

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()

[BHUVANESH]

Factor  is 0.25& Value is column value...

MROUND([COLUMN],0.25),,this is exactly Needed.

Mround Work concept

 

[MultiTech]

Perhaps some use of MOD() combined with something else.... 🤔

[WillowMobileSys]

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]

[BHUVANESH]

 

Factor  is 0.25& Value is column value...

MROUND([COLUMN],0.25),,this is exactly Needed

[BHUVANESH]

 

Factor  is 0.25& Value is column value...

MROUND([COLUMN],0.25),,this is exactly Needed

[SkrOYC · Accepted solution]

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

[BHUVANESH]

Oh Great.This Formula Is Working Correctly....Thank You Very Much