round down to nearest quarter

[delamarejames]

I have been unable to get an equation result to round down to the nearest quarter. We are making a form to verify information on labels for various bread products. The FDA has some regulations to determine what they term as "grains/bread servings". The equation is simply to divide the serving size (in grams) by 28, then round the result down to the nearest .25.

For example

34 gram roll 34/28=1.214.... the result is then rounded down to 1

55 gram bun 55/28=1.964.... is then rounded down to 1.75


I have tried mround but it always rounds to the closest .25 not down.


I would appreciate any help,

Thanks

 

[ahhhmed]

You can round 1.214 to 1

but 1.964 will be rounded to 2 beacause this is the nearest quarter.


Try this formula =ROUND(D1/0.25;0)*0.25 where D1 contains the value to be rounded.

 

[delamarejames]

Thank you for the quick response. I tried your suggestion and I got a "entered too few arguments" message. So I copied your suggestion changed D1 to the cell containing the value to be rounded and got a "formula contains an error" message

 

[delamarejames]

I just tried your suggestion changing the semi colon to a comma, it gave a result but is rounding up to nearest quarter

 

[delamarejames]

It works changing it to =rounddown(D1/0.25,0)*.25


Thank you so much

 

[Luke M]

I think you actually want the FLOOR function.

A1 = 2.356

A2 = 0.25

=FLOOR(A2,A2)

evaluates to 2.25

 

[shrivallabha]

If value 34 is in A1 then the formula should be:

=FLOOR(A1/28,0.25)

and then copied down.

 

[delamarejames]

Thank you all, the floor formula works as well, and is a bit cleaner