• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

NEED HELP

Please do not type in all Caps which is equivalent to shouting. If you have not read forum rules for beginners then please read them.
http://chandoo.org/forum/threads/new-users-please-read.294/

Regarding your post, please confirm how and where you want to put data for Opening Stock(Column B), Closing Stock(Column E) and Consumption (Column G). How do you want the consumption to be reported? Will it be in the same format as source data(<No. of Bottles>.<Loose ML>)?
 
Suppose openting stock as martini bianco is 1 bottles of 1000 ml and loose ml is 200 ml . i would type in column B opening value as 1.200 . (total is 1 litre 200 ml)
i want formula in Consumption (Column G).
 
See attached file which uses normal subtraction and 3 columns concerned have been formatted as Number | 3 Digits after decimal separator format.

Does this work as you want?
 

Attachments

if i follow your formula but formula not work in this condition. i have attached inventory sheet.supoose i have Cafe cream 700 ML (seal total 1,loose 155 ml)
in that case case formula show wrong answer.
 

Attachments

That's because you are using different volume to arrive at 1 bottle which is not standard mathematics.

In such cases, use below formula. If there's different size then change the 0.7 part (700/1000) e.g. if 600ml bottle is there then use 0.6:
=(INT(B7)*0.7+MOD(B7,1))-(INT(E7)*0.7+MOD(E7,1))
 
You must log in or register to reply here.
Back
Top