Re: Excel to track inventory?

Thanks, again for all your help! I think that I've got enough to manage my
inventory very nicely.

Again, congrats and good luck with the new baby!


--
Gary
Visit Lucy & Gary and do the jigsaw puzzle at
www.under-1-roof.com

"KC Rippstein" <kcrippsteinAThotmailDOTcom> wrote in message
news:eDYo2z8ZHHA.1300@xxxxxxxxxxxxxxxxxxxxxxx
Disregard that last post. I had it right the first time and should not
have second guessed myself. By leaving the *-1 outside the parenthesis,
it not only converts sales to positive numbers (deposits into your
account) but also converts inventory additions to negatives (purchases
from your account). Then if you wanted, at the top you could put a totals
row that uses the SUBTOTAL function to give yourself correct totals, even
if you apply a filter.
Hopefully my brain will work better today.

"KC Rippstein" <kcrippsteinAThotmailDOTcom> wrote in message
news:Oub5BG4ZHHA.348@xxxxxxxxxxxxxxxxxxxxxxx
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








.

Relevant Pages

  • Re: Lost Pet & Misc Questions
    ... Just hit "t" for throw and then the inventory letter of the item you ... When the game prompts you for an item to throw, ... > How do I find out my current base luck and/or item-added luck? ... No, the shopkeep will just stand there forever in his empty shop, ...
    (rec.games.roguelike.nethack)
  • DMS100 TABLE COMMANDS
    ... I am looking for assistance on finding information on the DMS100 ... TABLES, specifically the tables used for inventory (DN, LEN, FEATURE ... I haven't had much luck on the web, ...
    (comp.dcom.sys.nortel)
  • Re: Excel to track inventory?
    ... Basically, it's saying if you added inventory, multiply C2 by your ... cost. ... multiply C2 by your retail price and ... was incorrectly positioned after that parenthesis and should have been ...
    (microsoft.public.excel)
  • Re: motherboard/power supply incompatibility?
    ... Sparco has one Antec EPS12V: ... Search for "EPS12V" (good luck, ... they only listed the one in inventory, ...
    (comp.os.linux.hardware)
  • Re: Where can I find a basic tutorial for MS Access?
    ... > an inventory of material and equipment, ... sure the book will pay for itself. ... Good luck, ...
    (microsoft.public.access.gettingstarted)