If you consider spreadsheet formulas a programming language, and I do, then you could solve the Russian Peasant Multiplication challenge with a spreadsheet.
D3: =SUM(D4:D35)
A4: =B1
C4: =B2
D4: =IF(ISODD(A4),C4,””)
A5: =IF(OR(ISTEXT(A4),A4=1),””,INT(A4/2))
B5: =IF(OR(ISTEXT(A4),A4=1),””,”x”)
C5: =IF(OR(ISTEXT(A4),A4=1),””,C4*2)
D5: =IF(OR(ISTEXT(A4),A4=1),””,IF(ISODD(A5),C5,””))
Then filled down.
Just a different way
B3: =SUMPRODUCT((MOD(A4:A100,2)=1),C4:C100)
A4: =B1
B4: x
C4: =B2
A5: =FLOOR(A4/2,1)
B5: =IF(A5,”x”,””)
C5: =IF(A5,2*C4,0)
Fill down A5:C5.
Format A5:C100 #,##0;;
CF A4:C100 Formula is: “=MOD($A4,2)=0? Format: Font/Strikethrough
Note: I use MOD(x,2) rather than ISODD() or ISEVEN() to avoid the ATPA.
ISODD is ATP? Damn, I was wondering why I didn’t get intellisense. I really like RANDBETWEEN, otherwise I wouldn’t even have it installed.