Archive for the ‘Functions’ Category
Tuesday, September 4th, 2007
Text in a spreadsheet is not very useful unless you can do something with it. Fortunately, Numbers provides several functions for working with text.
Here is a quick look at some of the most useful text functions:
CONCATENATE(string1, string2, [string3,…])
Joins strings. Note: You can also use & (Ampersand) to join ...
Posted in Functions | No Comments »
Wednesday, August 29th, 2007
I found an interesting technique a while back on the Juice Analytics site, that works well in Numbers.
The technique uses the REPT Function, to create neat in-cell graphs.
The Numbers manual defines REPT as:
REPT(text, copies)
text: The text expression to be ...
Posted in Functions, Hacks, Tips | 2 Comments »
Friday, August 17th, 2007
Note: This post should hold true for both Numbers, and Excel, as the functions are identical.
The DATEDIF function finds the number of days, months, or years between two dates.
The format is DATEDIF(start-date, end-date, method)
- start-date and end-date are self explanatory
- method has several options:
"D" - counts the days between the ...
Posted in Functions | No Comments »
