Hi Experts,
Two situations here which needs a solution.
1) merging two different IF formulas in one cell, which should in sync with each other.
2) changing the values of a cell which contains IF formula, based on time duration which is validated from a list of multiple time frame.
Please find the attached file for your reference. Kindly revert for any clarification.
Jay
Hi Team,
Few of the cells in the worksheet were skipped and didn't included the formulas. Made the required amendment and hereby attaching the revised worksheet.
Hopefully, this would make more sense now.
Regards,
Jay
Hi Jay,
In the attached file I've made the following changes:
1. Formatted the data in an Excel Table - it makes the formula in column H easier to understand and follow.
2. Moved 'Today's Date' to a single cell and referenced it from the formula. The TODAY function is a volatile function so the use of it should be limited and I don't know how big this table of yours is likely to get.
3. I've formatted the Frequency list in a table and added a column for the number of days in each period. Please check you're happy with these.
4. Modified the formula in column H to allow for the different frequencies. Please check this formula is returning the results you'd expect.
Now, for your second question, here's what I think you're trying to say; you want the result in cell J5 returned in a single cell rather than using the two helper columns. If that's the case, I'd be inclined to leave it calculate in the two separate columns i.e. the way it is. It's more transparent this way.
Mynda
