+ Reply to Thread
Results 1 to 1 of 1

Adapting current formula to reflect a time period (otherwise = 0)

  1. #1
    Registered User
    Join Date
    12-02-2012
    Location
    Harrow
    MS-Off Ver
    Excel 2003
    Posts
    73

    Adapting current formula to reflect a time period (otherwise = 0)

    Currently wherever it says Void In table H6:Q8 - There will be a value in H11:Q11 (represented by =IF($C6="","",IF(M6="Void",$U5,0))

    I would like to adapt this so that this Value will only appear for the period equal to T6 (in this case 6months) and for the rest of the period = 0

    So if i used Row 6 as an example-
    In the cells M11:Q11 - I would like cells M11 & N11 to equal £100 and O11:Q11 to = 0

    (M11 & N11 reflect the period of 6 months (T6) or two quarters)

    Many thanks for any help
    Attached Files Attached Files

+ 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] Formula to reflect the 4th Wed. of the current month.
    By JO505 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-19-2013, 04:54 PM
  2. [SOLVED] Date Formula to Return Week Number in Current Month based on Reporting Period
    By jeversf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-25-2013, 12:10 PM
  3. [SOLVED] Complicated:Calculate time period based on no. of units sold + fluctuations within period
    By omaha.crab in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2012, 03:04 AM
  4. Formula to look up value in specific time period
    By chintanbtech in forum Excel General
    Replies: 0
    Last Post: 01-17-2012, 12:44 PM
  5. Replies: 2
    Last Post: 04-27-2011, 08:21 AM

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