Good morning,
What I would like is to have an IF statement (or something else if it is more appropriate) that checks the conditions present in a row and returns a variable for all conditions which are present.
For example, in the attached spread sheet, in O2. The if Statement has multiple conditions which equate to exceptions. However, there are more than 1 exception (i.e., more than one of the conditions exist) yet the IF formula only returns a single value.
In Row 2 there are 2 exceptions.
1) Exception: No Initial Payment Collected on Policy
2) Exception: Premium Payment Plan Timeline in Excess of Guidelines
However, the formula only returns the first true statement. I understand that this is not an error but it is also not have I have intended for it to work.
In summary, what is the best way to pull multiple true conditions and return all variables for which the condition is present?
Thanks!!
Bookmarks