Think of spreadsheets as an IDE for functional programming so your brain treats them as software.
Arguably, the more code works like a spreadsheet (functions transforming values, lists, or matrices) rather than stepwise ‘if this then that’ sequences, the better.
Put another way, logic can be woolier than math, in that concise mathematical formulation tends to removes ambiguity when reasoning over inputs to generate outputs.
Perhaps because I'm comfortable writing software it still feels very limiting to work within spreadsheets.