Transfer formula result from one tab to another on iCloud Numbers
I just tested this to be sure it worked. Go to the cell you want to copy and choose "Edit > Copy" or Hold down the Command key WHILE pressing the C key. Switch to the tab and cell you want to paste into then choose "Edit > Paste Formula Results" or Hold down the Command key AND Shift key WHILE pressing the V key.