Formula required (if condition)

Hi Team,

Required formula
1. If yellow fields = People, process, Technology, Out of scope is blank then final out should be blank.
2. if under people any number is entered then in the same row heading name should come under Final out come.
3. in the same way same condition is applicable for yellow colour fileds heading name should get updated in final status
4. could not go futher formula which I have entered in H2

Regards
Rk

Could you explain in rows where are numbers in People and Out of Scope (Out of Scope is higher) in the same time, should Out of Scope be the Final outcome, or both?

If we assume, that higher number becomes a final proces, formula in H1 should look like this:

Formula:

Please Login or Register  to view this content.

Explanation: If sum in particular row is more than 0 (so there have to be any number), then find propper hedding above the number
(heading row is no. 1 and column is given by MATCH formula). However, as you can see, it is based on the sum, because if there is just one number in a row, the sum always be that number.
In the case, where there are more numbers in a row, i used "1" as a last parameter in MATCH function with means "less than sum".
That means, it finds closest number smaller than sum of all numbers, wich will always be the higher number in the row.
Hope that is what you ment.