Numbers for Mac has always occupied an awkward position. It’s not powerful enough to replace Excel or Google Sheets for many business purposes, and it’s designed partly to be an interaction, quantitative-information presentation tool. Numbers for iOS had even more of a bias towards presentation until the latest update brought it a little more power.
However, Apple keeps pushing forward, and Numbers 5 for Mac has only a single significant change that Apple mostly underplayed, as most of the changes improve feature parity and seamless interchange between Numbers for Mac and iOS, while also making the apps more consistent with Pages (Mac and iOS) and Keynote (Mac and iOS).