Search results

Thank you bobhc, I tried a few times but have not succeeded in getting your solution to work. That is probably because I am a VBA virgin. I will keep trying to learn how to input your suggestion. Looking at your code will the range A:A change to B:B, C:C etc? for each successive column? What...

I haven't been able to find anything on this topic on my own. I am trying to put together a spreadsheet to compile orders from multiple customers. there are 86 possible items customers can order, but most days there are only 10 to 20 of the items ordered. I have the products listed in a column...

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

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

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

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

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...