Functions between separate tables in iCloud Numbers?

Discussion in 'Apple Music, Apple Pay, iCloud, Apple Services' started by laszlo182, Oct 4, 2014.

  1. laszlo182 macrumors regular

    Joined:
    Nov 17, 2013
    Location:
    Bratislava, Slovakia
    #1
    Hi
    I am working in iCloud Numbers and iOS Numbers (because of iCloud Drive:rolleyes:)
    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!
     
  2. bgro macrumors 6502a

    Joined:
    Jul 6, 2010
    Location:
    South Florida
    #2
    Yes you can do that you just need to reference the other table in your formula.
     

Share This Page