Project Euler Problem #1
Solved in Excel!
=SUMPRODUCT((MOD(ROW(A1:A999), 3)=0)*ROW(A1:A999))+SUMPRODUCT((MOD(ROW(A1:A999), 5)=0)*ROW(A1:A999))-SUMPRODUCT((MOD(ROW(A1:A999), 15)=0)*ROW(A1:A999))
Solved in Excel!
=SUMPRODUCT((MOD(ROW(A1:A999), 3)=0)*ROW(A1:A999))+SUMPRODUCT((MOD(ROW(A1:A999), 5)=0)*ROW(A1:A999))-SUMPRODUCT((MOD(ROW(A1:A999), 15)=0)*ROW(A1:A999))
June 6th, 2011 at 11:32 pm
… congrats?
And huzzah for array operations!
June 7th, 2011 at 4:56 pm
Euler is a playground for different languages and the like… I just thought it fun to solve the problem with something less like a “normal” programming language.
So yes, congrats. 🙂