Converting an if statement to a macro loop!

Converting an if statement to a macro loop!

7 nine 18 20 36
four 10 22 28 31
7 12 17 19 28
four 7 16 17 28
10 22 25 27 38

 

Above is columns b thru f . 

Below is my if statement:

 

=IF(B2=B3,”0″,IF(B2=C3,”1″,IF(B2=D3,”1″,IF(B2=E3,”1″,IF(B2=F3,”1″,IF(B2=B4,”0″,IF(B2=C4,”1″,IF(B2=D4,”1″,IF(B2=E4,”1″,IF(B2=F4,”1″,IF(B2=B5,”0″,IF(B2=C5,”1″,IF(B2=D5,”1″,IF(B2=E5,”1″,IF(B2=F5,”1″,IF(B2=B6,”0″,IF(B2=C6,”1″,IF(B2=D6,”1″,IF(B2=E6,”1″,IF(B2=F6,”1″,IF(B2=B7,”0″,IF(B2=C7,”1″,IF(B2=D7,”1″,IF(B2=E7,”1″,IF(B2=F7,”1″,IF(B2=B8,”0″,IF(B2=C8,”1″,IF(B2=D8,”1″,IF(B2=E8,”1″,IF(B2=F8,”1″,IF(B2=B9,”0″,IF(B2=C9,”1″,IF(B2=D9,”1″,IF(B2=E9,”1″,IF(B2=F9,”1″,IF(B2=B10,”0″,IF(B2=C10,”1″,IF(B2=D10,”1″,IF(B2=E10,”1″,IF(B2=F10,”1″,IF(B2=B11,”0″,IF(B2=C11,”1″,IF(B2=D11,”1″,IF(B2=E11,”1″,IF(B2=F11,”1″,IF(B2=B12,”0″,IF(B2=C12,”1″,IF(B2=D12,”1″,IF(B2=E12,”1″,IF(B2=F12,”1″,”CHECK”))))))))))))))))))))))))))))))))))))))))))))))))))

 

 

I did not know that excel has a restricted at the quantity of nested if statements.

Basically I would like to to find out if the numbers at the beginning row are in the similar place after they up to now gave the impression.  Place a 

0 for sure,  a one for no, and a take a look at if its now not inside vary.  I’d additionally like to be in a position to exchange the variability as opposed to beginning a new sheet within the workbook.

from checklist above  the third row in g thru okay 

zero   take a look at   1  take a look at   zero

 

Any lend a hand could be very much preferred.

Alchemist

Updated: January 22, 2020 — 10:34 pm

Leave a Reply

Your email address will not be published. Required fields are marked *