Useless Blogging

June 6, 2011

Project Euler Problem #1

Filed under: Programming — steegness @ 4:57 pm

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))

(Project Euler)

2 Responses to “Project Euler Problem #1”

  1. Jason Says:
    June 6th, 2011 at 11:32 pm

    … congrats?

    And huzzah for array operations!

  2. steegness Says:
    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. 🙂