Q: What separator should be used between arguments in a formula in Numbers, a comma or a semicolon?

In Apple's Numbers , the separator used between the arguments of a formula mainly depends on your regional settings, particularly the decimal separator. Numbers automatically inserts a comma (,) between arguments when you select cells, but you need to replace it with a semicolon (;) if the decimal separator for your location is a comma (as is the case in French). For example, in France where the decimal separator is the comma, you should write: =SUM(A1;A2;A3) and not: =SUM(A1,A2,A3) This distinction is important because using a comma as an argument separator in a French-speaking locale would create ambiguity: the comma would be both your decimal separator and your argument separator. That is why Numbers allows you to replace the automatically inserted comma with a semicolon when adding cell references. In summary: if your system uses a comma as the decimal separator (French, Belgian, Swiss French localization, etc.), use the semicolon to separate the arguments. If you are using an English-speaking locale where the decimal separator is the point, the comma can generally be retained.

Question 1

How to use the Apple Magic Trackpad 3?

Accepted Answer

The Apple Magic Trackpad 3 is a wireless pointing device that offers a large and responsive touch surface, allowing you to perform various actions through multitouch gestures.

Main features and gestures of the Magic Trackpad 3:

Click: Press anywhere on the surface to perform a click.
Right-click: Click with two fingers simultaneously.
Scrolling: Slide two fingers vertically or horizontally to scroll through a page or document.
Zoom: Pinch with two fingers to zoom in or out.
Rotation: Rotate two fingers to turn an image or compatible object.
Swipe between applications: Swipe three or four fingers left or right to switch from one full-screen app to another.
Mission Control: Swipe three or four fingers up to display Mission Control and see all open windows.
Desktop: Swipe three or four fingers down to show the desktop.

Usage tips:

Make sure the Magic Trackpad 3 is properly connected via Bluetooth to your Mac.
In System Preferences > Trackpad, you can customize gestures and adjust pointer speed.
The Magic Trackpad 3 is compatible with macOS and requires a recent version to enjoy all multitouch features.

By using these gestures and options, you will be able to fully take advantage of your Magic Trackpad 3 for smooth and intuitive navigation.

Question 2

How to perform a conditional sum of a column in Numbers on Mac based on a specific value in the previous column?

Accepted Answer

In Apple Numbers on Mac, to perform a conditional sum of a column based on a specific value in the previous column, you need to use the SUMIF function. This function evaluates the cells in a range according to a criterion and sums the corresponding values from another range.

The basic syntax is as follows: =SUMIF(criteria_range, "value", sum_range). For example, if you have categories in column A and amounts in column B, and you want to sum the amounts only for a specific category, you would write: =SUMIF(A:A, "Category", B:B). This formula will check each cell in column A and only sum the values in column B when column A exactly matches your value.

To set up this formula in your Numbers sheet, first select the cell where you want to display the result. Then, click on the function icon (fx) in the toolbar or use the Insert > Function menu to open the function browser. Search for SUMIF and select it to get an input assistant that will guide you in setting the parameters.

It is recommended to specify the exact ranges rather than entire columns for clarity and performance. For example, use =SUMIF(A2:A100, "value", B2:B100) if your data is between rows 2 and 100, thus excluding headers. Remember that the criterion value must exactly match the text or number in the previous column; case sensitivity may not always be ignored depending on your settings.

If you have multiple conditions to apply (for example, summing based on two different columns), Numbers cannot handle multiple criteria in a single SUMIF function. The solution is to create several distinct SUMIF formulas and sum them in a separate cell with a simple addition, for example: =SUMIF(A:A, "Category1", B:B) + SUMIF(A:A, "Category2", B:B).

Question 3

How to insert and use a checkbox in a formula in Apple Numbers?

Accepted Answer

In Apple Numbers, it is possible to insert a checkbox in a cell and use it in formulas to create conditional calculations or dynamic displays.

Steps to insert a checkbox:

Select the cell where you want to add the checkbox.
Open the Format panel by clicking on the corresponding icon at the top right.
In the Cell tab, change the Cell Type by selecting Checkbox.

Using the checkbox in a formula:

The checkbox has a boolean value: TRUE if checked, FALSE if unchecked. You can therefore use it directly in your formulas.

For example, if the checkbox is in cell A1, you can write a formula in another cell to display text based on its state:

=IF(A1; "Enabled"; "Disabled")

This formula will display "Enabled" if the checkbox is checked, and "Disabled" otherwise.

Usage examples:

Calculate a value only if the checkbox is checked: =IF(A1; B1 * 2; 0)
Count the number of checked boxes in a range: =COUNTIF(range; TRUE)

These features allow you to make your tables interactive and customized according to your needs.

Question 4

How to turn off and restart an iPhone 8?

Accepted Answer

To turn off and restart your iPhone 8, follow the steps below:

Turning off the iPhone 8

Press and hold the side button (on the right side of the device) and one of the volume buttons (either volume up or volume down) simultaneously.
When the Slide to power off slider appears on the screen, slide it to the right to turn off the device.

Turning on the iPhone 8

Press and hold the side button until the Apple logo appears.
Release the button and wait for the iPhone to fully start up.

Question 5

How to automatically turn a cell red in Numbers when a date is 15 days from the current date?

Accepted Answer

To automatically turn a cell red in Numbers when the date it contains is 15 days from the current date, you can use the conditional formatting feature. Here are the steps to follow:

Select the cell or range of cells containing the dates to check.
In the toolbar, click on the Format button (at the top right).
In the panel that opens, choose Conditional Formatting.
Click on Add a Rule.
In the dropdown menu of rules, select Date is.
Choose the option "in the next 15 days" or "in the 15 days before" depending on whether you want to include future or past dates.
Then set the formatting style, for example, the text or background color to red.
Confirm by clicking on Done.

This rule will automatically apply the red color to cells whose date is within 15 days of the current date, thus facilitating the visualization of upcoming deadlines.

Question 6

What separator should be used between arguments in a formula in Numbers, a comma or a semicolon?

Accepted Answer

In Apple's Numbers, the separator used between the arguments of a formula mainly depends on your regional settings, particularly the decimal separator. Numbers automatically inserts a comma (,) between arguments when you select cells, but you need to replace it with a semicolon (;) if the decimal separator for your location is a comma (as is the case in French).

For example, in France where the decimal separator is the comma, you should write:

=SUM(A1;A2;A3)

and not:

=SUM(A1,A2,A3)

This distinction is important because using a comma as an argument separator in a French-speaking locale would create ambiguity: the comma would be both your decimal separator and your argument separator. That is why Numbers allows you to replace the automatically inserted comma with a semicolon when adding cell references.

In summary: if your system uses a comma as the decimal separator (French, Belgian, Swiss French localization, etc.), use the semicolon to separate the arguments. If you are using an English-speaking locale where the decimal separator is the point, the comma can generally be retained.

User manual APPLE : user manuals and guides in PDF

Models APPLE most viewed

Browse manuals APPLE by appliance type

Recent questions about devices APPLE