Forum Discussion
Solved
help with formulas
Hello I need to find what kind of formula to complete a project that I have probably is super simple but I don't get it column W have non-DOT and DOT column T has time in seconds I need to...
- an example of a formula that you can use to update column V based on the conditions you mentioned:
```
=IF(AND(W2="non-DOT", T2>90, T2<181), "ON TRACK", IF(AND(W2="DOT", T2>300, T2<601), "ON TRACK", ""))
```
This formula uses the `IF` and `AND` functions to check if the value in column W is "non-DOT" and the time in column T is greater than 90 seconds and less than 181 seconds. If these conditions are met, then it returns "ON TRACK". If not, it checks if the value in column W is "DOT" and the time in column T is greater than 300 seconds and less than 601 seconds. If these conditions are met, then it also returns "ON TRACK". If neither of these conditions are met, it returns an empty string.
You can enter this formula in cell V2 and then drag it down to fill the rest of the cells in column V. This will update the values in column V based on the conditions you mentioned.
I hope this helps!
an example of a formula that you can use to update column V based on the conditions you mentioned:
```
=IF(AND(W2="non-DOT", T2>90, T2<181), "ON TRACK", IF(AND(W2="DOT", T2>300, T2<601), "ON TRACK", ""))
```
This formula uses the `IF` and `AND` functions to check if the value in column W is "non-DOT" and the time in column T is greater than 90 seconds and less than 181 seconds. If these conditions are met, then it returns "ON TRACK". If not, it checks if the value in column W is "DOT" and the time in column T is greater than 300 seconds and less than 601 seconds. If these conditions are met, then it also returns "ON TRACK". If neither of these conditions are met, it returns an empty string.
You can enter this formula in cell V2 and then drag it down to fill the rest of the cells in column V. This will update the values in column V based on the conditions you mentioned.
I hope this helps!
```
=IF(AND(W2="non-DOT", T2>90, T2<181), "ON TRACK", IF(AND(W2="DOT", T2>300, T2<601), "ON TRACK", ""))
```
This formula uses the `IF` and `AND` functions to check if the value in column W is "non-DOT" and the time in column T is greater than 90 seconds and less than 181 seconds. If these conditions are met, then it returns "ON TRACK". If not, it checks if the value in column W is "DOT" and the time in column T is greater than 300 seconds and less than 601 seconds. If these conditions are met, then it also returns "ON TRACK". If neither of these conditions are met, it returns an empty string.
You can enter this formula in cell V2 and then drag it down to fill the rest of the cells in column V. This will update the values in column V based on the conditions you mentioned.
I hope this helps!
Thank you so much
It works
It works