Hi All,
I've officially given up. Can anyone see the problem with the formulas contained in Cell D30 on the attached. I'm trying to achieve is the following but I've tried different permeatations . Using Cell D30 as the example (it's the closest I've got so far) I'm trying to achieve the following:
- First rule: If the date in Column A on row 30 is not greater than the date in cell A2, the cell D30 should show zero
- Second rule: If the date in D20 is greater than or equal to the date in A30 AND is also less than the date in A31, then;
- If the date in A30 is greater or equal to the date in D12 AND less than or equal to the date in D14 (i.e. if A30 falls within the date range of D12 and D14), then the result should be D17 plus D19 but;
- If the date in A30 is less than the date in D12 OR greater than the date in D14 (i.e. if A30 falls outside the date range of D12 and D14), then the result should be D17 but;
- Third rule: if the date in D20 is less than A30 or greater than A31 (i.e. falls outside the date range of A30 and A31) then:
- If A30 is greater than or equal to D12 AND less than or equal to D14, then the result should be D19 else;
- The result should be zero
Bookmarks