juanito
Member
@John Jairo V I believe I managed to replicate your LET function using Named Formulas. Thanks so much for your help.That is awesome, sir! My (corporate) version of 365 doesn't support LET yet - however I believe I may be able to replicate the functionality using named formulas... it may take me a day or two to confirm.

See attached. One more thing: I seem to have resolved this without recourse to either your variable f or the complex SWITCH / CHOOSE ... your thoughts?
juanito