Calculating values based on multiple criteria

My 4 input ranges are:
G3:Q3; G17:Q20; AH17 & BA18:BA22

G3:Q3 is either of 1 or 0 with a condition that maximum number of 1 occurrence will be one.
G17:Q20 is either 0 or a positive number
AH17 is either 0 or a positive number and is continuously updating with RTD feed.
BA18:BA22 is a numeric.

2 Output ranges are AM16:AU25 & G22:Q22 (formulas are required for these 2 ranges).

IF I19<I18=TRUE (I18 is the corresponding upper cell).
IF I17>J17>0=TRUE OR I17>AH17=TRUE
IF I20>J20>0=TRUE OR I20>AH17=TRUE
IF I3 (corresponding cell in G3:Q3)=0, then

IF TRUE; TRUE; TRUE; TRUE OR IF FALSE; TRUE; TRUE; TRUE then AN19 (3rd cell)=I19 else 0
IF TRUE; TRUE; TRUE; TRUE then AN18=I18 else 0
IF TRUE; TRUE; TRUE; TRUE then AN24=0 else IF FALSE; FALSE; FALSE; TRUE then I18 else 0
IF TRUE; TRUE; TRUE; TRUE then AN25=0 else IF FALSE; FALSE; FALSE; TRUE then I19 else 0
IF TRUE; TRUE; TRUE; TRUE OR IF FALSE; TRUE; TRUE; TRUE then AN16=1 else IF FALSE; FALSE; FALSE; TRUE then 2 else 0

Formulas required for AN19; AN18; AN24; AN25; AN16

Similarly, formulas required for AO19:AU19; AO18:AU18; AO24:AU24; AO25:AU25; AO16:AU16

IF G17:Q17=BA19 AND IF G19:Q19=BA22 AND BA18<0 then corresponding G22:Q22=10
IF G17:Q17=BA19 AND IF G19:Q19=BA22 AND BA18>0 then corresponding G22:Q22=20
Else 0

Formula required for G22:Q22

Also IF G3:Q3=0 (there is no 1); then both output ranges=0

I am ready to add helper rows/columns.
Queries would be appreciated.

How to accomplish? Thanks in advance.

Paragraph #6: IF TRUE; TRUE; TRUE; TRUE OR…… then 2 else 0

I delete this paragraph #6 & re write it as:
1. AN19=I19 IF answers of the above 4 criteria’s are (TRUE, TRUE, TRUE, TRUE) respectively OR (FALSE, TRUE, TRUE, TRUE) respectively; else =0
2. AN18=I18 IF answers of the above 4 criteria’s are (TRUE, TRUE, TRUE, TRUE) respectively else =0
3. AN24=0 IF answers of the above 4 criteria’s are (TRUE, TRUE, TRUE, TRUE) respectively else =I18 IF answers of the above 4 criteria’s are (FALSE, FALSE, FALSE, TRUE) respectively else =0
4. AN25=0 IF answers of the above 4 criteria’s are (TRUE, TRUE, TRUE, TRUE) respectively else =I19 IF answers of the above 4 criteria’s are (FALSE, FALSE, FALSE, TRUE) respectively else =0
5. AN16=1 IF answers of the above 4 criteria’s are (TRUE, TRUE, TRUE, TRUE) respectively OR (FALSE, TRUE, TRUE, TRUE) respectively; else=2 IF answers of the above 4 criteria’s are (FALSE, FALSE, FALSE, TRUE) respectively else =0

I hope this satisfies.
Please feel free to raise more queries if required.

The column I (from 5th paragraph) is taking care to fill the results in column AN (6th paragraph)