Benches Uncategorized

4

formulas that reference the same cell more than...

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

Here is a formula that references the same cell more than once:

Vo = Vi*(R1/(R2+R1))

When I try to enter this in Numbers 2009 (this used to work in 08) the second time I click on the cell for R1 the cell ref does not appear in the formula bar... the original tag for that cell highlights instead.

Image: !http://contello.net/Site/numbers/Screenshot2009-09-28at8.55.10PM!

You can work around this by typing... but if I wanted to type i'd use expr on the terminal

Has anyone seen this?

4 replies

Sign in or join Beachball Help to reply.

  1. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    For the second and later times, hold down the command key then click.

  2. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    OK. That is stoopid [sic]-- not you comment but the change in behavior. What is that consistent with?

  3. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Oh, and thanks!

  4. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    I never had the previous version but I am perplexed as to why they chose to require the command key for this. I constantly forget and it messes me up. If you are looking you will see it puts a hand instead of a plus sign on the cell until you press command. So it is visually obvious. Still gets me, though.