AFZAL SOHAIL
Board Regular
- Joined
- May 31, 2023
- Messages
- 146
- Office Version
- 2021
- 2016
- Platform
- Windows
Hello the team:-
I need a nested if formula as shown in the below:-
Thanks in advance please.
I need a nested if formula as shown in the below:-
Thanks in advance please.
SR.NO. | DATE | DAY | TIME IN | TIME OUT | status | |
1 | 01-06-24 | SATURDAY | 9.56 | 17.51 | of | |
2 | 02-06-24 | SUNDAY | off | |||
3 | 03-06-24 | MONDAY | 10.39 | 17.52 | late | |
4 | 04-06-24 | TUESDAY | 9.54 | 17.55 | ok | |
5 | 05-06-24 | WEDNESDAY | 10.39 | 17.56 | late | |
6 | 06-06-24 | THURSDAY | 9.56 | 18.02 | ok | |
7 | 07-06-24 | FRIDAY | GREEN | green | ||
8 | 08-06-24 | SATURDAY | 9.55 | 17.59 | ok | |
I need if formula is as | ||||||
1.col-D if smaller than or equal to 10.00 then in status col it is ok | ||||||
2.col-D if greater than 10.0 then in status col it is late | ||||||
3.if col-D is blank then status is off | ||||||
4.if col-d is written green than in status col it is green |