Casey_0307
New Member
- Joined
- Sep 7, 2021
- Messages
- 7
- Office Version
- 2016
- Platform
- Windows
Hi Everyone
I have a excel sheet that is setup in this way and we are not allow to change. May I seek the community's help on if it is possible to build a formula not only to check the value at the latest date, but if the the most recent date results is >8 then, then the outcome should be = 1, otherwise is should be 0.
E.g. If the most recent Date of Test is is 28-Dec2021 (i.e. Date of Test 4), the outcome we expect is 0 as the results of Test 4 is less than 8.
I am using Excel 2016. Thank you for looking into my post.
I have a excel sheet that is setup in this way and we are not allow to change. May I seek the community's help on if it is possible to build a formula not only to check the value at the latest date, but if the the most recent date results is >8 then, then the outcome should be = 1, otherwise is should be 0.
E.g. If the most recent Date of Test is is 28-Dec2021 (i.e. Date of Test 4), the outcome we expect is 0 as the results of Test 4 is less than 8.
Date of Test 1 | Results of Test 1 | Date of Test 2 | Results of Test 2 | Date of Test 3 | Results of Test 3 | Date of Test 4 | Results of Test 4 |
7-Jul-2021 | 7.8 | 8-Dec-2021 | 10 | 19-Dec-2021 | 7 | 28-Dec-2021 | 7 |
I am using Excel 2016. Thank you for looking into my post.