+ Reply to Thread
Results 1 to 4 of 4

Check the cost are on the desired quarter

  1. #1
    Registered User
    Join Date
    08-13-2020
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    50

    Check the cost are on the desired quarter

    In a spreadsheet I have a desired cost programme - ie the cost has to be spent in that given period.

    And detailed breakdown of the cost.

    How do I ensure check that the cost are always within required quarter.


    In the attached, the cost for row 25 starts on Jun-21 quarter and but should be one quarter before that based on the value of E25 (As this is error on some formula say in A25 like if cost start and finish within the quarter then True else false)

    Also, the value on row 23, should finish on the Mar-21 quarter (based on the value of E18) but finishes one quarter late.
    Attached Files Attached Files
    Last edited by chaliseyp; 11-09-2020 at 04:04 PM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Check the cost are on the desired quarter

    You were not hugely clear about what you wanted, but try 2 formulae, like this one:

    =IFERROR(CHOOSE(SIGN(MATCH(E25,$H$9:$P$9,1)+1-MATCH(TRUE,INDEX(($H25:$P25>0),0),0))+2,"Late","On Time","Early"),"")

    See the sheet for context.
    Attached Files Attached Files
    Glenn



  3. #3
    Registered User
    Join Date
    08-13-2020
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    50

    Re: Check the cost are on the desired quarter

    That does the job Glen

    Thanks a lot

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Check the cost are on the desired quarter

    You're welcome.



    If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

    It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Check if expenses are on the given quarter
    By saravnepali in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-16-2020, 03:07 AM
  2. Please check the e date formula for desired result
    By akshay6s in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 09-10-2019, 02:02 AM
  3. Replies: 8
    Last Post: 12-24-2018, 07:14 AM
  4. Determining Margin Formula, I know cost and margin desired.
    By Draftdude in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-15-2018, 06:08 AM
  5. Replies: 2
    Last Post: 11-28-2017, 09:20 AM
  6. [SOLVED] How do I work out the sell price from cost, desired margin and success fee?
    By westnz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-17-2016, 04:08 AM
  7. Replies: 3
    Last Post: 01-15-2016, 10:51 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