[Solved] IF Then question with division

[BecJ]

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

 

[shamimarita]

Hello Becj,

You will need to combine the IF function in an Excel formula:

1. First, use the IF function to check the condition.
2. Then, use nested IF functions to handle multiple conditions.

Here is an example formula that you can put in a cell to achieve this:
=IF(F2="Most Restrictive", N2/10, IF(F2="Least Restrictive", N2/5, ""))
In this formula:

• F2 is the cell that contains the value to check ("Most Restrictive" or "Least Restrictive").
• N2 is the cell that contains the length of time to be divided.

You can drag this formula down to copy it to other rows in your worksheet.