need an assist for formula

[hussein_elsayed]

Dears,

i need your assistance regarding the attached sheet that including combounded formula if you have any idia to mak it easier than it is specialy when i need to add a new project.

Thanks in advance

[#2]

That's quite a bit of logic. You might want to explore the LET function to make it more readable and remove the redundancies.
https://support.microsoft.com/en-us/office/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999