Calculating values based on multiple criterias

[bittubadri]

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.

[AliGW]

By adding a poll, which I have amended but cannot remove, you are putting yourself in the position where your thread may well be ignored.

As a result, so that you have the best chance of being helped, I am closing this thread.

Please open a new one with NO POLL ATTACHED.

Thanks.