Check out Formula and Function Basics In Numbers at YouTube for closed captioning and more options.
Formula and Function Basics In Numbers
Comments: 9 Responses to “Formula and Function Basics In Numbers”
Haven't played with printing. Just experiment and try different things, like moving the table. As for filling, it works similar to how it did before.
Hi Gary, Wonderful your explanation, I myself have been working with excel but love to change to numbers. I have one with this: =ALS(EN(C26"";D26"");D26/C26;"")
ALS = as EN = and. Can I put this formula into numbers?
Thanks for your reply.
Piet van 't Zelfde The Netherlands
Sorry, I don't know what that formula does. Looking at a list of Excel functions, I don't see an AS function and I'm not sure what the quote marks mean in your formula. What are you trying to do?
Any chance you can help with a SUMPRODUCT issue? I know that Numbers does not work with arrays in the sam way as Excel so I am having problems with a spreadsheet I migrated. The Excel sheet uses the following formula:
=SUMPRODUCT((Scores::Table 1::$F$1:$F$5000=$B4)×(Scores::Table 1::$E$1:$E$5000>Scores::Table 1::$D$1:$D$5000))
Basically, it checks to see how many home wins there are by a specific team (B4). I get an error that says the formula uses a Boolean instead of a number.
I don't see how using SUMPRODUCT makes sense for what you are trying to do. There are many ways I can think of to do it. For instance, you could add another column to each row that uses IF to put the name of the winner of each game. Another column could then repeat that name only if the home team won. Then use COUNTIF to get the total number of times each team name appears in that collection of cells. Or, use COUNTIFS to do it. There are so many ways, but I don't see how SUMPRODUCT helps.
Gary, After using Excel forever I was lost with Numbers and then I found your videos. Thanks for making the transition so much easier, in fact I finally even enjoy using Numbers.
That is so simple and I was always having trouble with formulas.
Thanks Gary, you example of how to search formulas and find examples of their use helped me to find and use the roundup formula i needed to keep track of credit card pos fees.
Just update my numbers to mavericks and when create a table on new numbers, I cannot center on a page portrait/Landscape, also auto dil cells when doing a list. Please help me out.