Create custom formula/function? Is this even possible in Numbers

Question

Level 1

0 points

Create custom formula/function? Is this even possible in Numbers

I have 4 tables. 1 table to display information from the other three. In the three I have check boxes and a number in the box next to it. What I want to do in the information table is say add up (in each table) the numbers if the check box next to it is true. Pretty much I need to write something with a loop that ends when its checked each box in a table if the check box is TRUE and then add the number beside it if it is true. If anyone wants the actual file email me and I will send it to you to show you exactly what I am talking about. zach.burkhart@gmail.com.

Pretty much is there a way to make your own function

I am running Numbers '09

MacBook Pro 2.4GHz 4GB RAM, Mac OS X (10.5.6)

Posted on Mar 18, 2009 3:11 PM

Reply

Answer 1

Mar 18, 2009 6:19 PM in response to alphapyro360

Yes.

Download both the Numbers09_UserGuide.pdf and iWork09_FormulasandFunctionsUserGuide.pdf from under the Help menu.

Peter

Reply

Answer 2

Badunit

Level 7

30,714 points

Mar 18, 2009 6:54 PM in response to alphapyro360

What it sounds like you are looking for is the SUMIF function. The example below looks for checked boxes in cells B8 through B11 and, if checked, adds the value from the corresponding row in column C.

C13=SUMIF(B8:B11,TRUE,C8:C11)

Reply

Answer 3

Badunit

Level 7

30,714 points

Mar 18, 2009 9:31 PM in response to Badunit

On the subject of creating your own function, it depends on what you mean by "creating". If you mean writing your own code and giving it a function name so you can call it in a cell (or multiple cells), then the answer is no. You can use any valid combination of the provided functions in a cell but there is no provision for writing your own new function. If there is, I sure didn't see it in the manuals.

Reply

Answer 4

KOENIG Yvan

Level 8

41,819 points

Mar 19, 2009 1:36 AM in response to Badunit

My guess is that the OP want something like the MACRO() function available in AppleWorks.
It allows us to create our own functions in AppleScripts.

I wrote a lot of them for AppleWorks and will be glad to get such feature in Numbers.

_Go to "Provide Numbers Feedback" in the "Numbers" menu_, describe what you wish.
Then, cross your fingers, and wait _at least_ for iWork'10 😉

Yvan KOENIG (from FRANCE jeudi 19 mars 2009 09:36:01)

Reply