Results 1 to 10 of 10

Using min and if formula I would like to get cost based off of the start and end date.

Threaded View

David713 Using min and if formula I... 07-27-2017, 11:48 AM
leelnich Re: Using min and if formula... 07-27-2017, 01:08 PM
David713 Re: Using min and if formula... 07-27-2017, 01:47 PM
leelnich Re: Using min and if formula... 07-27-2017, 02:01 PM
AliGW Re: Using min and if formula... 07-27-2017, 01:49 PM
David713 Re: Using min and if formula... 07-27-2017, 01:58 PM
David713 Re: Using min and if formula... 07-27-2017, 02:08 PM
leelnich Re: Using min and if formula... 07-27-2017, 02:41 PM
David713 Re: Using min and if formula... 07-27-2017, 02:54 PM
leelnich Re: Using min and if formula... 07-27-2017, 03:02 PM
  1. #1
    Registered User
    Join Date
    07-27-2017
    Location
    HOUSTON
    MS-Off Ver
    2013
    Posts
    15

    Using min and if formula I would like to get cost based off of the start and end date.

    I would like to tell people in 2015 for this item(apple or orange or pears or grapes) we ate this much using column f and g.
    I would like to put this formula in Column d2

    Column A
    date
    10/1/2015
    9/1/2016
    9/3/2015
    9/3/2015
    9/3/2015
    2/23/2017

    Column B
    item
    APPLE
    ORANGE
    PEARS
    GRAPES
    APPLES
    PEARS

    Column C
    cost
    0
    20
    8
    7
    5
    10

    Column D
    MIN 2015
    =need formula here

    Column F
    START DATE
    1/1/2015

    Column G
    END DATE
    12/31/2015
    Last edited by David713; 07-27-2017 at 01:56 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 03-26-2016, 08:29 PM
  2. Replies: 2
    Last Post: 03-06-2016, 09:22 PM
  3. Replies: 2
    Last Post: 03-06-2016, 11:05 AM
  4. Replies: 3
    Last Post: 03-06-2016, 11:02 AM
  5. Replies: 2
    Last Post: 03-06-2016, 11:02 AM
  6. [SOLVED] Help in writing formula in excel to produce dates based on start date and end date
    By shoot for moon in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-10-2014, 01:00 PM
  7. Replies: 3
    Last Post: 10-23-2012, 09:04 PM

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