Everyone can use 10 lbs of Munich, Vienna, and Malted wheat for sure.
sounds good! (yuo wonder why you go put in charge......)
After seeing the price list what kinds are everyone interested in?
suggestions
change the formula in cell L19 to be
=IF((SUM(L4:L18)<11), 1,2)
change the formula in cell M19 to be
=IF((SUM(M4:M18)<11), 1,2)
change the formula in cell N19 to be
=IF((SUM(M4:M18)<11), 1,2)
These changes above make it so the number of bags purchased is 1 if there are less than 11 people wanting a bag and 2 if it's greater than 11. It changes to the second bag when the bag size would drop below 5lb bags. I didn't take into account getting more than 22 people wanting any 1 specialty grain.
make the formula for cell L25 to be
=55/(SUM(L4:L18))
M25 would be
=55/(SUM(M4:M18))
N25 would be
=55/(SUM(N4:N18))
This would show the size of each bag if its divided up. If someone is ordering 2 then they get twice the number shown. This assumes all of them are 55lb bags, if there not just change to the size they are.
Can ya tell I'm bored with work?
suggestions
change the formula in cell L19 to be
=IF((SUM(L4:L18)<11), 1,2)
change the formula in cell M19 to be
=IF((SUM(M4:M18)<11), 1,2)
change the formula in cell N19 to be
=IF((SUM(M4:M18)<11), 1,2)
These changes above make it so the number of bags purchased is 1 if there are less than 11 people wanting a bag and 2 if it's greater than 11. It changes to the second bag when the bag size would drop below 5lb bags. I didn't take into account getting more than 22 people wanting any 1 specialty grain.
make the formula for cell L25 to be
=55/(SUM(L4:L18))
M25 would be
=55/(SUM(M4:M18))
N25 would be
=55/(SUM(N4:N18))
This would show the size of each bag if its divided up. If someone is ordering 2 then they get twice the number shown. This assumes all of them are 55lb bags, if there not just change to the size they are.
Can ya tell I'm bored with work?
It might make payments easier if you set up a paypal account. Just thinking...
It might make payments easier if you set up a paypal account. Just thinking...
I couldn't either, all I could figure out was to download it as .xls and then do it in excel and re-upload it.
You want me to ask my local Home brew club?
Enter your email address to join: