Hi all-
If you ever run into a multi state condition where you want to map functions to states you can use something like 1 1 1 0 0 1 0 0 1 0 and call the functions in a nested if statement on your sheet based on the need for the mapping.
thanks,
j.