I am trying to create a formula that takes a specific answer in a column then looks at a cell that has length of time and needs to be divided by a number. This formula also has to account for two different responses and if it is the second response there will be a different number it will be divided by.
Here are the two examples:
1) Column F returns a value of Most Restrictive, the formula then needs to look at column N
Here are the two examples:
1) Column F returns a value of Most Restrictive, the formula then needs to look at column N