Rounding formula question.

[jtorres85]

Hello everyone!

I own a bakery and I'm trying to create an ingredient inventory sheet. Each night I have a sheet that updates automatically how many dough batches I should make. The batches must be whole numbers since I can't make a half batch of something with the large mixer that I'm using. So I created a rule that if the decimals in a batch are greater than or equal to .33 then I round up to the next whole number. If the decimals in the batch are less than .33 I round down.

Example:

Monday Night
Plain bagel dough: 4.33 ( I would make 5 plain bagel doughs)
Wheat bagel dough: 4.25 (I would make 4 wheat bagel doughs)
Sesame bagel dough: 4.5 (I would make 5 sesame bagel doughs)

And so on. Basically I need a formula that will allow me to round up at or equal to .33 instead of .50 and round down if it is less than .33. The reason why its .33 and not .50 is that each batch makes 12 bagels and so that would mean that I would be minus 6 entire bagels if I rounded down at .49 and would not have enough to fill my orders.

Any thoughts?

If you're in the Chicago land area, a dozen free bagels are up for grabs to the person that can help me out!

Thanks in advance,

The Bageler

 

[Scott Huish]

=ROUND(A2+0.17,0)

Copy down.

Excel Workbook
	A	B	C
1	Dough	Make	Type
2	4.33	5	Plain
3	4.25	4	Wheat
4	4.5	5	Sesame
Sheet1

 

[jtorres85]

=round(a2+0.17,0)

copy down.

sheet1

*	a	b	c
dough	make	type
4.33	5	plain
4.25	4	wheat
4.5	5	sesame

<tbody>
[TD="bgcolor: #cacaca"]1[/TD]

[TD="bgcolor: #cacaca"]2[/TD]

[TD="bgcolor: #cacaca"]3[/TD]

[TD="bgcolor: #cacaca"]4[/TD]

</tbody>

spreadsheet formulas

cell formula b2 =round(a2+0.17,0) b3 =round(a3+0.17,0) b4 =round(a4+0.17,0) <tbody> </tbody>

<tbody>
</tbody>

excel tables to the web >> excel jeanie html 4

you are king

thank you!