help with formulas

Question

HelloI need to find what kind of formula to complete a project that I haveprobably is super simple but I don't get itcolumn W have non-DOT and DOTcolumn T has time in secondsI need to update column V with: non-DOT ON TRACK &gt;90secs and &lt;181secs&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DOT ON TRACK &gt;300secs and &lt; 601secs&nbsp;Can someone help me

h2o · Accepted Answer

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!

Forum Discussion

help with formulas

2 Replies