I'm trying to format a google sheet to calculate the amount of raw lumber I need to purchase for a given project.

Raw lumber is sold in quarters, so for example 4/4 is a one inch board, 5/4 is an inch and a quarter, and so on.

I've managed to format my cell to always output a number over 4, so if I input 1 1/8 final dimension it will give me 6/4 in raw lumber (final dimension + 1/4"). but the problem I run into is that there are certain sizes that lumber isn't sold in, like 7/4, 9/4 and 11/4.

Is it possible to force a cell to round up to a given list of numbers: 4/4, 5/4, 6/4, 8/4, 10/4, and 12/4

Here is my sheet:

https://docs.google.com/spreadsheets/d/1iZfVLeJdres8nJSghDfm-ibGlbFqYEoMIdgnY-MnWvQ/edit?usp=sharing

If you set the number in cyan (thickness final dimensions) to 2, the number in yellow (thickness raw lumber) goes to 9/4, but that isn't an option I would like it to bump up to 10/4. Same goes for any instance where it would show up as 7/4 or 11/4.

New contributor
fred is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • Fred, yes, this is possible. But I/we would need to see your sheet (or a copy of it) in order to write formulas or talk to you in a meaningful way about how and where to set things up. If you'd like, use File > Share to create a link, being sure to select "Anyone with the link can Edit" (not just "...can View") and share that link here. – Erik Tyler Dec 8 at 15:05
  • Hi thanks Erik I've edited my post to add the link. – fred 2 days ago
  • Thanks for sharing the sheet. In taking a look, and even with your description thus far, it's not clear to me what the sheet overall is supposed to do, and which cells would be doing calculations that you want rounded up. Feel free to jot notes on the sheet itself, and then comment back here. I'll take another look then. – Erik Tyler yesterday

Your Answer

fred is a new contributor. Be nice, and check out our Code of Conduct.

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.