Forum Discussion
Patrick2788
May 12, 2023Silver Contributor
Create a 'Triforce' array (Sierpiński Triangle) with a formula
I've been studying 'pyramid' arrays lately and with a new Zelda title out, I was inspired to generate a left-justified 'Triforce' array with a formula. Sierpiński triangle - Wikipedia Triforce - Wi...
mtarler
May 12, 2023Silver Contributor
ok this ISODD() (pun intended). there are a couple of errors in your output and I don't think due to the formula. In particular on cell(26,11) the calculation is COMBIN(25,10) which = 3268760 and the result of ISODD is TRUE. This is the classic roundoff / representation inside of excel causing issues so you need to add INT() around that COMBIN (or around the N)
Patrick2788
May 12, 2023Silver Contributor