Register
Log In
Unanswered
Home
July 23, 2017
Offline
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
July 23, 2017
Offline
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
July 16, 2010
Online
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
Most Users Ever Online: 57
Currently Online: Mynda Treacy
16 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
sugi gunawan
janja mesec
John DiMartino
lizette acosta
eric johnson
Kim Bond
Nichelle Stevens
Manuel Rodriguez
peter wang
Amit Kanekar
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
