Variables in numbers?

Hi!

I've got a Social Studies assignment, you can read my awesome translation here 🙂

The assignment itself is rather easy, you don't have to do a function at all, but I'd like to automatically distribute the seats. The problem is that I'm used to programing syntax, and variables. Is there any way to use variables in Numbers? If you look at the result, you can see that I've tried to use cells as variables, but since it doesn't read from the upside down, but rather everything at the same time I doesn't work. It creates a loop, and I get errors. Or is there any other solution? How would you do it?

Am I thorough enough? Otherwise; ask away!

Thanks in advance,

Oskar Modig

MacBook Pro, Mac OS X (10.7.2)

Posted on Feb 2, 2012 8:29 AM

17 replies

KOENIG Yvan

Level 8

41,819 points

Feb 9, 2012 4:57 AM in response to Punchlinern

OK.

I made a small change.

In B3, I edited the formula as :

=ROUND(B$2/LOOKUP(SUM($K$2:K2),Table 2 :: $A,Table 2 :: $B),2)

You're right, the column Divider was just inserted to display what was puzzling me.

You may remove it.

Don't try to shorten the formulas used in the range B3:I13 this way :

B3 : =ROUND(B$2/J3,2)

it would introduce the infamous circular references with their red triangle.

Yvan KOENIG (VALLAURIS, France) jeudi 9 février 2012

iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.3

My Box account is : http://www.box.com/s/00qnssoyeq2xvc22ra4k

Please, click the Badunit message as the correct answer.

It's this one which gave the formulas.

Punchlinern Author

Level 1

0 points

Feb 9, 2012 5:23 AM in response to KOENIG Yvan

Thank you very much!

I won't, I'm not familiar enough with Numbers, and the syntax yet, but you (both of you) have help me one the way towards something 🙂

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Variables in numbers?