I'm switching from Microsoft Excel to Number.app, in Excel you can do
a1:a10-b1 bit will return a cell range equivalent to
a1:a10 but with all the cells decremented by
b1. What's the proper syntax in Numbers for that?
If I try to import an Excel workbook using that syntax into Numbers, that formula will be imported verbatim and Numbers will complain.