B
bretkennedy
Just wondering, i am trying to do a stock sheet for my bar to purchas
product.
I have a number of colums. the 2 most important colums are
1. Cases required (ie: order stock by the case)
2. Units required (stock by the unit)
what i would like to do is, in my total colum, i would like to have
formula that checks that particular stocks row for either case or item
If there is a value in that row, take the value in that row, multiply i
by a price value, which can either be by the case or by the unit, an
then put the value of the item to purchase in the total column.
in my head i understand what i am saying, i hope this makes sense.
if cell x > 0 ( or maybe it should be a true or false value) the
multiply x by y.
that is the basic formula. But i want the formul to check both cells
unit and case. There will never be an instance where i am ordering
single unit and a case so they won't clash like that.
Is there a way to right the formla so that it checks the unit and cas
columns and if there is a value multiply it by its respective price t
return a value?
cheers
bre
product.
I have a number of colums. the 2 most important colums are
1. Cases required (ie: order stock by the case)
2. Units required (stock by the unit)
what i would like to do is, in my total colum, i would like to have
formula that checks that particular stocks row for either case or item
If there is a value in that row, take the value in that row, multiply i
by a price value, which can either be by the case or by the unit, an
then put the value of the item to purchase in the total column.
in my head i understand what i am saying, i hope this makes sense.
if cell x > 0 ( or maybe it should be a true or false value) the
multiply x by y.
that is the basic formula. But i want the formul to check both cells
unit and case. There will never be an instance where i am ordering
single unit and a case so they won't clash like that.
Is there a way to right the formla so that it checks the unit and cas
columns and if there is a value multiply it by its respective price t
return a value?
cheers
bre