Numbers for Mac: The most important formulas
- To be able to a date, use the formula "DATE". Then, specify the cells where the day, month and year are specified. You can also use the "TIME", "HOUR", "MINUTE" or "calendar week".
- You want to calculate your working days, use the formula for "net working days". You will then need to only have to work when you started and when labour was the end. A similar formula is also available for Excel.
- Also the duration you can in the spreadsheet easily calculate. The formulas "DAUERINTAGEN", "DAUERINSTD", "DAUERINMS", "DAUERINMIN", "DAUERINSEK" and "DAUERINWO" at your disposal.
- Of course, the common mathematical formulae such as "SUM", "ROUND", "ROUND", "square sum", or "ROUND up" in Numbers are available to you.
- You can use the formula of "COMPARISON" and then specify at least two cells, to compare the values with each other.
- For the calculation of the mathematical mean value, you can simply enter the formula "AVERAGE" and then select cells.
- A number of by the formula "NUMBER of" very easy and fast to calculate. Do not use "ANZAHL2", to take account of only empty cells.
- Alternatively, you can use to Count certain cells of the command "COUNTIF". To do this, you need to specify in the formula to a specific criterion.
Mac: formulas for Numbers
You will learn in the next practice tip on how you in Numbers, create a chart can.
