July 23, 2017
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.
July 23, 2017
July 16, 2010
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.
Most Users Ever Online: 57
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
John Ryan Kivela
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas