hello,
im trying to make a spreadsheet for my dad to calculate the type of milk delivered and quantity so he can look at the database on a specific day and be able to place an order from his suppler for all the milk needed. so say column C is Mondays milk i want to put at the bottom a formula to add up milk needed and type of milk
so the values i need to use for different types will be
s/b = small blue
s/g = small green
b/b = big blue
b/g = big green
p = silver
S = red
b = blue
st = sterilized
o/j = orange juice
eg = eggs
each with a number infront to say how much 1s/b = 1 small blue
any help would be greatly appreciated as a formula like this is way over my head its using excel 2002
thanx very much
Daz
im trying to make a spreadsheet for my dad to calculate the type of milk delivered and quantity so he can look at the database on a specific day and be able to place an order from his suppler for all the milk needed. so say column C is Mondays milk i want to put at the bottom a formula to add up milk needed and type of milk
so the values i need to use for different types will be
s/b = small blue
s/g = small green
b/b = big blue
b/g = big green
p = silver
S = red
b = blue
st = sterilized
o/j = orange juice
eg = eggs
each with a number infront to say how much 1s/b = 1 small blue
any help would be greatly appreciated as a formula like this is way over my head its using excel 2002
thanx very much
Daz
