trying to lookup a value and return if true or fals

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
 
K

Ken Johnson

Hi Bret,
If...
column B is "# cases ordered"
column C is "# items ordered"
column D is "Price per case"
column E is "Price per item"

then this formula in column E calculates the cost for the stock on row
2...

=IF(B2>0,B2*D2,IF(C2>0,C2*E2,""))

Ken Johnson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top