LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 63
Default Excel formula for inventory problem

I am unable to figure out how to get the formula below to work properly. It
is for figuring out the amount of product sold for the year where B3=cost of
item,C3=starting inventory on Jan 1st, D3=inventory purchased between Jan.
1st and 3/31, E3=inventory on 3/31, F3=inventory purchased between Apr. 1st
and 6/30, G3=inventory on 6/30, H3=inventory purchased between Jul. 1st and
9/30, I3=inventory on 9/30, J3=inventory purchased between Oct. 1st and
12/30, and K3=ending inventory on 12/31. The formula help for excel is very
poor and confusing. It will not actually tell me what the specific problem
is, nor how to fix it.

=SUM(B3*(C3+D3(-(IF(AND(E3=0,G3<0),E3,0))),(IF(AND(G3=0,I3<0),(+ F3-G3),0)),(IF(AND(I3=0,K<0),(+F3+H3-I3),0)),(IF(K3=0),(+F3+H3+J3-K3),0)))

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel IF Formula for an inventory... Allan Grates Excel Discussion (Misc queries) 11 October 25th 08 08:07 PM
Formula needed for too much inventory Angela Excel Worksheet Functions 4 January 17th 07 08:10 PM
inventory comparison formula?? willy Excel Worksheet Functions 5 April 1st 06 03:24 PM
Need help with a formula in inventory zipper21 Excel Discussion (Misc queries) 2 March 31st 06 11:38 AM
How can i get an inventory list that adds and subtracts inventory James Excel Discussion (Misc queries) 0 October 5th 05 12:48 AM


All times are GMT +1. The time now is 05:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"