Re: Excel to track inventory?

This:
=IF(C2<>"",C2*IF(C2>0,VLOOKUP(B2,Inventory!A:B,2,0),VLOOKUP(B2,Inventory!A:C,3,0))*-1,"")
should also be corrected to:
=IF(C2<>"",C2*IF(C2>0,VLOOKUP(B2,Inventory!A:B,2,0),VLOOKUP(B2,Inventory!A:C,3,0)*-1),"")
Basically, it's saying if you added inventory (C2>0), multiply C2 by your
cost. Otherwise, multiply C2 (a negative number) by your retail price and
then multiply it by -1 (since you want positive revenues, right??). My *-1
was incorrectly positioned after that parenthesis and should have been
inside the parenthesis.
That should do it. Thanks for the congrats!

"Gary" <gary@xxxxxxxxxxxxxxxx> wrote in message
news:O58%23t32ZHHA.348@xxxxxxxxxxxxxxxxxxxxxxx
Congratulations!!!!!!! Good luck to you and your growing family!!!!!
Thanks, again for taking the time to help me with this!

--
Gary
Visit Lucy & Gary at
www.under-1-roof.com

"KC Rippstein" <kcrippsteinAThotmailDOTcom> wrote in message
news:OL7Cru0ZHHA.2436@xxxxxxxxxxxxxxxxxxxxxxx
... Sorry, I was in a hurry to get to our sonogram today...after 2 boys,
we are now having a girl!

Good luck!
-KC




.