Converting an if statement to a macro loop!

Reply #3

alchemist7 — Fri, 24 Jan 2020 13:17:23 GMT

Yes i found that out the hard way! I'm using 365 subscription because I use multiple pcs. I think I can get my loop started after a little more searching. Hopefully I'll be able to write and test it out this weekend.

Reply #2

JADELottery — Thu, 23 Jan 2020 15:32:57 GMT

Excel 2007 maximum nested function levels is 64.

Other Excel version might be different.

Reply #1

AllenB — Thu, 23 Jan 2020 01:04:48 GMT

Instead of trying to do this with a single formula try to do this by column or row and break it into 5 Different formulas.

I did not really look at what you are doing, but it looks like you might want to set up the formula to include an indirect and address function. That would let you change the value or cell that you want to watch.

Let me know if you need some help by PM and i might be able to help

Allen

Converting an if statement to a macro loop!

alchemist7 — Wed, 22 Jan 2020 15:59:45 GMT

7 9 18 20 36

4 10 22 28 31

7 12 17 19 28

4 7 16 17 28

10 22 25 27 38

Above is columns b through 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... [ More ]