Hello, please need help, add IF formula some more condition.

[zeko90]

Hello, i need some help with formula.

Most is in the attachemend.

1. know i have this formula :IF(B3=A3;"";IF(OR(B3=0;A3=0);B3;"Error")) Then i have problem i don't know how can i do it now

I do this because some of forcest values are allready incount in conformed and i don't want this. And some of the focest values can be confrmed values for 5 colums back

2. now we must look not just one value back but two: C3 and A3 this is first new condition
do this to for 5 values back (J2 look back to A2, C2; E2, G2, I2) then not need any more. We must look Conformed values

3. IF we look formula for F15 must contian condition if C3=A3 take into account the last one !

4. get it all together



Thanks everyone for help realy