+ Reply to Thread
Results 1 to 2 of 2

calculating days of stock

  1. #1
    Cor
    Guest

    calculating days of stock

    Hi,

    I need a formula for this in:
    Coloms
    A | B | C | D | E | F | G | H etc
    Stock (today) |<DAYS OF STOCK> |sales tomorrow | Sales day after tomorrow| forecast day 1| forcast day 2| forcast day 3| etc

    100 | | 15 | 12 | 18 | 25 | 34


    The outcome in column B must be apr. 4,88 which is 4 day's +


    Thanks in advance,






  2. #2
    Bill Kuunders
    Guest

    Re: calculating days of stock

    You could have something like
    =A2/average(C2:L2) which will give you 4.807

    You could also just deduct the sum of projected days from the stock to see
    a positive or negative balance.
    =A2-SUM(C2:L2) which will give you -4

    Allowing for your etc.... up to L column.


    --
    Groeten vanuit Nieuw Zeeland
    Willy Kuunders
    "Cor" <cor@whatuwant.nl> wrote in message news:d5geft$grr$1@news2.zwoll1.ov.home.nl...
    Hi,

    I need a formula for this in:
    Coloms
    A | B | C | D | E | F | G | H etc
    Stock (today) |<DAYS OF STOCK> |sales tomorrow | Sales day after tomorrow| forecast day 1| forcast day 2| forcast day 3| etc

    100 | | 15 | 12 | 18 | 25 | 34


    The outcome in column B must be apr. 4,88 which is 4 day's +


    Thanks in advance,






+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1