Multiple IF AND Condition

Dears
Hope this email finds you Well.

The attached sheet is just a sample data, I need write a formula in Column [G] to combine multiple IF AND condition with different result.

The If condition with AND condition will be combined together to scan the whole column [B] who has the same contract number.

The below formula is what I am trying to write to get the final result :-

If the colum [C "contract status" ="ACTV"] and colum [E "Sub Status" has NO value like "NSUB" ], then G2 "No Nsub"], If the colum [C "contract status" ="ACTV"] and colum [E "Sub Status" has value like "NSUB" ] and column [F "Amount due $" for the Sum of All NSUB value <30$>0$] ,then G2"<30$>0$"], If the colum [C "contract status" ="ACTV"] and colum [E "Sub Status" has value like "NSUB" ] and column [F "Amount due $" for the Sum of All NSUB value >=30$] ,then G2 ">=30$"], If the colum [C "contract status" ="ACTV"] and colum [E "Sub Status" has value like "NSUB" ] and column [F "Amount due $" for the Sum of All NSUB value <30$] ,then G2 "<=0$", "<=0$"].


BR

Dear Sambo kid
Appreciated your feedback and sorry to reply too late.

Can we amend the formula to incorporate the following changes :-

At Column [G3]
1)- Group column [B "Contract Number"] by contract number, the attached list having 4 different groups.
2)- IF X group contract is having [Contract Status like "ACTVE"], If True move to step 3 else write in each row for the same contract group "<>ACTVE".
3)- IF X group contract is having [Sub Status like "NSUB"] if True, move to Step 4, else write in each row for the same contract group "<>NSUB".
4)- IF X group contract [Total amount due for all NSUB ">=30$", if True, write in each row for the same contract group ">=30$",if not move to step 5.
5)- IF X group contract [Total amount due for all NSUB "<30$>0$", If True, write in each row for the same contract group "<30$>0$",if not move to step 6
6)- IF X group contract [Total amount due for all NSUB "<=0$", If True write in each row for the same contract group "<=0$".


Sorry of any inconvenience.

BR

Dear Sambo;
Thanks for your feedback.

I am grateful for your continuous support .

Please check the attached file [Sheet2] for easy reference.

BR

Dear Sambo;
Marvelous and incredible solution.

BR