Numbers: Dividing a column by a fixed reference cell in anther sheet in a multi-sheet spreadsheet
Solution 1:
I don't have an iPad, however, on a Mac, settings the formula in, e.g., a cell in Table 1 on Sheet 1, referencing from Sheet 2, it would be, e.g,:
=B2/Sheet 2::Table 1::C2
Note that if you want to preserve the row and column reference use, e.g.:
=B2/Sheet 2::Table 1::$C$2
Obviously changing the cell, sheet and table references as appropriate.
Note that when the formula window is open, one can click on a cell in a different sheet to add its reference to the formula. One can then click on the down arrow to click either Preserve Row or Preserve Column.
