Back
Other

Excel formulas ITA

Study material for Laboratorio di Impianti Industriali, shared by the Studwiz community and reviewed by moderators.

Laboratorio di Impianti IndustrialiOther

Document information

What's included in this study material

Study material for Laboratorio di Impianti Industriali, shared by the Studwiz community and reviewed by moderators.

Import quality: text was extracted directly from the original document.

Extracted content from the document

Representative passages recognised in different parts of the material. The full extracted text remains available to search, while this compact preview makes the page easier to read.

Page 1

Excel formulas: Italian vs English CheatSheet by aeniGma aka Eremita Solitario (http://www.thekey.it) ADESSO() NOW() AMBIENTE.INFO(tipo) INFO(type_text) AMMORT.ANNUO(costo;val_residuo;vita_utile;periodo) SYD(cost;salvage;life;per) AMMORT.COST(costo;val_residuo;vita_utile) SLN(cost;salvage;life) AMMORT.FISSO(costo;val_residuo;vita_utile;periodo;mese) DB(cost;salvage;life;period;month) AMMORT.V AR(costo;val_residuo;vita_utile;inizio;fine;fattore;...) VDB(cost;salvage;life;start_period;end_period;factor;no_switch) AMMORT(costo;val_residuo;vita_utile;periodo;fattore) DDB(cost;salvage;life;period;factor) ANNO(num_seriale) YEAR(serial_number) ANNULLA.SPAZI(testo) TRIM(text) ARCCOS(num) ACOS(number) ARCCOSH(num) ACOSH(number) ARCSEN(num) ASIN(number) ARCSENH(num) ASINH(number) ARCTAN.2(x;y) A TAN2(x_num;y_num) ARCTAN(num) A TAN(number) ARCTANH(num) A TANH(number) AREE(rif) AREAS(reference) ARROTONDA.DIFETTO(num;peso) FLOOR(number;significance) ARROTONDA.ECCESSO(num;peso) CEILING(number;significance) ARROTONDA.PER.DIF(num;num_cifre) ROUNDDOWN(number;num_digits) ARROTONDA.PER.ECC(num;num_cifre) ROUNDUP(number;num_digits) ARROTONDA(num;num_cifre) ROUND(number;num_digits) ASIMMETRIA(num1;num2;...) SKEW(number1;number2;...) ASS(num) ABS(number) BAHTTESTO(num) BAHTTEXT(number) CASUALE() RAND() CELLA(info;rif) CELL(info_type;reference) CERCA.ORIZZ(valore;matrice_tabella;indice;intervallo) HLOOKUP(lookup_value;table_array;row_index_num;...) CERCA.VERT(valore;matrice_tabella;indice;intervallo) VLOOKUP(lookup_value;table_array;col_index_num;...) CERCA(...) LOOKUP(...) CODICE.CARA TT(num) CHAR(number) CODICE(testo) CODE(text) COLLEG.IPERTESTUALE(posizione_collegamento;...) HYPERLINK(link_location;friendly_name) COLONNE(matrice) COLUMNS(array) COMBINAZIONE(num;classe)…

Preview

First page of the document.

First page: Excel formulas ITA