Forum Discussion
Help with IFS Please
Y/n columns refer to active and key accounts(being D and F), dated columns refer to last service and last contact(being E and J).
I'm hoping to provide this formula so as if the accounts are not active, a follow up is flagged; if an account is active but the parameters with in the formula for dates fall out of range(ie =180 days and/or +365 days) a follow up is flagged.
https://1drv.ms/x/s!Aui5lVRDPQjas2QgD4a9ihQevy7u?e=sLMzim
Hope this has worked??
I'm real new at the more int/adv features of excel.
Is the priority of these ifs where they exist in the formula?
Ideally if both were yes I'd like it to only run off the dated ifs, but the dated ifs would always have more weight. Does this make sense?
Hope this has worked??
Assuming you're referring to the link to the OneDrive file: YES, it works.
I'm real new at the more int/adv features of excel.
So are we all at some point in our lives. Fortunately there's this site, as well as many others on the internet. You should (if you haven't already) check out the many YouTube channels with help on various Excel functions. I also find ExcelJet to be a valuable resource and commend it to you.
Is the priority of these ifs where they exist in the formula?
Yes. In the case of the IFS function, the function stops when it comes to a condition that is met. So you need to write them with that in mind, putting them in sequence.
Ideally if both were yes I'd like it to only run off the dated ifs,
but the dated ifs would always have more weight. Does this make sense?Yes, it makes sense. But you are far more familiar than I with the data, and it's YOUR interpretation that should come more readily, so I need to rely on you to go through all those rows and determine if you're getting the result you need, and to identify where you're not and why. I assume, since you're coming here for help, that there are some rows that are not working, but which ones? What conditions aren't being evaluated as desired?
It would help, actually, if you created a "developmental" spreadsheet containing a limited number of cases, each designed to test a condition or two. Having the whole universe to run through just makes it harder to identify the anomalies.
HINT: (and this is just a guess), it may be that the use of the AND function would help, if in fact there are conditions that are combinations of conditions. For example, to test if both D4 and F4 are "Yes" a syntax like this
=IFS(AND(D4="Yes",F4="Yes"),whatever.....