Excel formula in Numbers

Discussion in 'Mac Apps and Mac App Store' started by stressymum, Feb 22, 2010.

  1. stressymum macrumors newbie

    Joined:
    Feb 22, 2010
    Location:
    Buckinghamshire
    #1
    I am a newly converted Mac user and have some entrenched Excel habits, and try as I might, I couldn't locate this Excel formula in Numbers.

    In Excel, I use "=C55 (or cell reference)" to copy that particular value from one worksheet to another. I do this by clicking on the cell where I want the value to be copied to, type = and then switch to the other worksheet and click on the cell I want to copy. And voila, I am now back onto my 1st worksheet with the value showing. I do this because the value I want to copy to this cell changes regularly.

    If anyone could help with this, I would most appreciate it. Thank you.
     
  2. mysterytramp macrumors 65816

    mysterytramp

    Joined:
    Jul 17, 2008
    Location:
    Maryland
    #2
    That's how it SHOULD work in Numbers, too. Could just be there's a subtle change in gestures. At any rate, you can refer to cells within tables:

    =C55

    Within sheets:

    =Table 1 :: C55

    Within environments:

    =Sheet 1 :: Table 1 :: C55

    When they work, the reference is "bubbled" in a pastel color.

    Quick Numbers plug -- not sure Excel does this, and it's pretty cool -- Let's say you have a table with columns 2008, 2009 and 2010; and rows Sales and Total.

    You can refer to them:

    =Total 2010

    or even

    =2010 Total

    No extra naming needed.

    mt
     
  3. flat five macrumors 601

    flat five

    Joined:
    Feb 6, 2007
    Location:
    newyorkcity
    #3
    right, that's exactly how numbers works also..
    what is happening to you when you try it?
     

Share This Page