How Make Automatic Watering

Basics
This one of the most fundamental lesson is to know how to use Excel. This program is a "spreadsheet", it is important to know how to use formulas. The formulas are made up of four basic operations: addition, subtraction, multiplication and division. In front of each formula fits the seng = (equal). The signs of some operations are not like those who write on the sheets, but in the computer calculation of the signs are: + for addition, - for subtraction, * for multiplication and / for division ( Warning If you use the other bar \\, exit the error because this character does not assume the meaning Division! ). Ex
formula: 1- Write the first term in a cell and another cell in the second term;
2-In another cell still need to write the following formula: = Name of the cell operation signs of Name 'other cell.
Example: On 1- A1 and A2 we write we write 5 6
2-A3 write on the following formula: = A1 + A2. Hit return to get the result
Powers
To obtain the result of a power we must have this formula: = Number of base ^ exponent number.
Example: write on any cell: = 10 ^ 3. Press enter and you could get the result.

Expressions in Excel and all other types of spreadsheets, there are no braces or brackets, but only the round. So we have put in expressions only in parentheses.
Example: 1 - write on a cell: = ((55 * (8-2)) / 10) +10. As a result, where being 43.
Logical operators
Excel performs the calculation with logical operators, indicating whether the given condition is true or false. Key players are < ( Minor ) > ( Major ) and = ( Same ).
Es. formula: =Condizione 1 Operatore logico Condizione 2.
Esempio pratico: =5>2. Premendo il tasto "Invio" nella cella dove è stata immesa la formula, comparirà il risultato, cioè Vero , perchè 5 è maggiore di 2.
La congiunzione
La congiunzione avviene mettendo il carattere " &amp; " (Maiusc+6). Questa funzione mette insieme le due parole messe tra virgolette.
Es. formula: ="Parola 1"&amp;"Parola 2"
Esempio partico: ="Dopo"&amp;"domani". Il risultato è Dopodomani.
All other formulas can be found on the bar multifunctional Excel Formulas tab .

Share on Facebook