Results 1 to 1 of 1

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have already posted this in the excel forum- As its the final piece that i need to complete my spreadsheet i was hoping for an answer as quick as possible.

    http://www.excelforum.com/excel-formulas-and-functions/943057-adapting-current-formula-to-reflect-a-time-period-otherwise-0-a.html


    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 be populated with 100 and O11:Q11 to be populated with 0

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

    Many thanks for any help
    Attached Files Attached Files

Posting Permissions

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