Results 1 to 5 of 5

Excel 2007 : Formulae required for a stock report

Threaded View

  1. #1
    Registered User
    Join Date
    04-21-2009
    Location
    Manchester
    MS-Off Ver
    Excel 2007
    Posts
    6

    Angry Formulae required for a stock report

    Hi

    I need to create formulaes for a spreadsheet to give me the detail below:-

    Column A is 50
    Column B is O.5 current stock coverage what column A equates to
    Column B is 21/04/2009 (todays date)
    Column C is 2.5 is stock coverage I need to have at any given time.
    Column D is stock on order
    Column E is what I need to order to reach 2.5 (formulae required)
    Column F is (formulae required) date I will be at 2.5.

    Sorry new to the forum, hope I have explained appropriately.
    Last edited by lindalou; 04-21-2009 at 07:22 PM. Reason: wrong etiquette for site

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