software

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 gt; 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: www.excelforum.com/member.php...oamp;userid=33136
View this thread: www.excelforum.com/showthread...hreadid=529447Hi Bret,
If...
column B is quot;# cases orderedquot;
column C is quot;# items orderedquot;
column D is quot;Price per casequot;
column E is quot;Price per itemquot;

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

=IF(B2gt;0,B2*D2,IF(C2gt;0,C2*E2,quot;quot;))

Ken Johnson