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
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