Just wondering, i am trying to do a stock sheet for my bar to purchase
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 a
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 it
by a price value, which can either be by the case or by the unit, and
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) then
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 a
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 case
columns and if there is a value multiply it by its respective price to
return a value?

cheers

bret


--
bretkennedy
------------------------------------------------------------------------
bretkennedy's Profile: http://www.excelforum.com/member.php...o&userid=33136
View this thread: http://www.excelforum.com/showthread...hreadid=529447

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(B20,B2*D2,IF(C20,C2*E2,""))

Ken Johnson