top | item 46339351

(no title)

The descriptions of the problems make it sound a little like algorithmic puzzles but your only tool is Excel instead of some programming language… Excel is pretty amazing in what you can do; I’ve regretted having to use Google Sheets for the last few years.

discuss

shagie|2 months ago

> but your only tool is Excel instead of some programming language

There is little difference between (if (> a b) c d) and =IF((A1 > B1), C1, D1)

Excel is the most widely installed functional programming language IDE.

OoooooooO|2 months ago

Change the language of your Windows system to anything but English and then open your Excel file with formulas again.

lmz|2 months ago

It even has LAMBDA now: https://support.microsoft.com/en-us/office/lambda-function-b...

Bridged7756|2 months ago

Yup. Not too long ago they added Python scripting. Definitely beats the weird cloud scripting you have to do with Google Sheets.

HPsquared|2 months ago

Excel Python runs in the cloud. It is nicely integrated though.