Hi
I am working in iCloud Numbers and iOS Numbers (because of iCloud Drive)
I would like to have 2 different tables but a functions operating with data in each other.
The first table contains the amount of people. In the second there are prices. I would like to have a function in the second table that does this: [amount of people] * [price] so I can calculate the total amount of money paid and divide it by the amount of people so they will know how much to pay.
Is it possible to do it or I have to put all the data in one table? If it could be in 2 tables it would be much much clearer (yes, I know that I can format one table so it looks like there are two but actually having two is easier and quicker).
Thank you!
I am working in iCloud Numbers and iOS Numbers (because of iCloud Drive)
I would like to have 2 different tables but a functions operating with data in each other.
The first table contains the amount of people. In the second there are prices. I would like to have a function in the second table that does this: [amount of people] * [price] so I can calculate the total amount of money paid and divide it by the amount of people so they will know how much to pay.
Is it possible to do it or I have to put all the data in one table? If it could be in 2 tables it would be much much clearer (yes, I know that I can format one table so it looks like there are two but actually having two is easier and quicker).
Thank you!