need nested if formula

[AFZAL SOHAIL]

Hello the team:-
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​

 

[Joe4]

Put this formula on row 2 and copy down:

=IF(D2="","off",IF(D2="GREEN","green",IF(D2<=10,"ok",IF(D2>10,"late",""))))

By the way, based on your description, I think row 2 in your example should be showing "ok", not "of".

 

[AFZAL SOHAIL]

Put this formula on row 2 and copy down:

=IF(D2="","off",IF(D2="GREEN","green",IF(D2<=10,"ok",IF(D2>10,"late",""))))

By the way, based on your description, I think row 2 in your example should be showing "ok", not "of".

Thanks a lot Sir, it is working very well , I am sorry for row 2 mistake it is actually "ok" not "of"

 

[Joe4]

You are welcome.
Glad I was able to help.