Auto-Populate Project Status

[Seoham]

Hello,

I am trying to find a way to auto-populate the status of a project from a list of projects. Each Project has a "Start Date", and "End Date", "duration". And their Status is Off-track, Risk to timeline, Working as per schedule, Not started, Activity completed.
I want the formula to consider the start date and end date with progress percentage.

	Project Start Date:	Sat, 23-04-2022		Display Week:	0
#	Project (User Input)	Project Owner (User Input)	Start Date (User Input)	Duration	End Date (User Input)	Progress	Status
1	Project Breeze	Hirsch	24-04-2022	40	10-05-2022	24%
1.1	Task 1	Hirsch	24-04-2022	12	06-05-2022	25%
1.2	Task 2	Hirsch	24-04-2022	12	06-05-2022	50%
1.3	Task 3	Hirsch	24-04-2022	16	10-05-2022	31%
2	Command Program	Samora	01-05-2022	13	09-05-2022	31%
2.1	Task 1	Samora	01-05-2022	3	04-05-2022	67%
2.2	Task 2	Samora	01-05-2022	2	03-05-2022	50%
2.3	Task 3	Samora	01-05-2022	8	09-05-2022	63%
3	Project Point	McFay	09-05-2022	27	19-05-2022	30%
3.1	Task 1	McFay	09-05-2022	8	17-05-2022	63%
3.2	Task 2	McFay	09-05-2022	9	18-05-2022	22%
3.3	Task 3	McFay	09-05-2022	10	19-05-2022	10%
4	Project Mecha	Wood	17-05-2022	21	23-05-2022	48%
4.1	Task 1	Wood	17-05-2022	9	26-05-2022	22%
4.2	Task 2	Wood	17-05-2022	6	23-05-2022	50%
4.3	Task 3	Wood	17-05-2022	6	23-05-2022	83%
5	Program Pad	Ladd	25-05-2022	25	03-06-2022	52%

I tried this formula with if condition on status column >>
=IF(G25=0%,"Not Started",IF(G25<20%,"Off Track",IF(G25<=50%,"Risk to timeline",IF(G25<95%,"Work progressing Per Schedule",IF(G25=100%,"Activity Completed"))))
But it does not seem right.

Thank you in advance.