LOG
LOG(value, base)
Returns the the logarithm of a number given a base. Learn more
Analisi dati
Apri schedaFunzioni Google Sheets
Una scheda strutturata per ogni funzione: sintassi, argomenti, esempi pratici, errori comuni, FAQ e collegamenti a formule correlate.
Digita almeno 2 lettere per vedere i suggerimenti.
79 formule trovate · pagina 2 di 2
Non sai da dove partire?
Percorsi per livello e use case
Base
Intermedio
Avanzato
Use case
Sfida del giorno
LOG10
LOG10(value)
Returns the the logarithm of a number, base 10. Learn more
Analisi dati
Apri schedaMOD
MOD(dividend, divisor)
Returns the result of the modulo operator, the remainder after a division operation. Learn more
Analisi dati
Apri schedaMROUND
MROUND(value, factor)
Rounds one number to the nearest integer multiple of another. Learn more
Analisi dati
Apri schedaMULTINOMIAL
MULTINOMIAL(value1, value2)
Returns the factorial of the sum of values divided by the product of the values' factorials. Learn more
Analisi dati
Apri schedaMUNIT
MUNIT(dimension)
Returns a unit matrix of size dimension x dimension. Learn more.
Analisi dati
Apri schedaODD
ODD(value)
Rounds a number up to the nearest odd integer. Learn more
Analisi dati
Apri schedaPI
PI()
Returns the value of Pi to 14 decimal places. Learn more
Analisi dati
Apri schedaPOWER
POWER(base, exponent)
Returns a number raised to a power. Learn more
Analisi dati
Apri schedaPRODUCT
PRODUCT(factor1, [factor2, ...])
Returns the result of multiplying a series of numbers together. Learn more
Analisi dati
Apri schedaQUOTIENT
QUOTIENT(dividend, divisor)
Returns one number divided by another. Learn more
Analisi dati
Apri schedaRADIANS
RADIANS(angle)
Converts an angle value in degrees to radians. Learn more
Analisi dati
Apri schedaRAND
RAND()
Returns a random number between 0 inclusive and 1 exclusive. Learn more
Analisi dati
Apri schedaRANDARRAY
RANDARRAY(rows, columns)
Generates an array of random numbers between 0 and 1. Learn more.
Analisi dati
Apri schedaRANDBETWEEN
RANDBETWEEN(low, high)
Returns a uniformly random integer between two values, inclusive. Learn more
Analisi dati
Apri schedaSEC
SEC(angle)
The SEC function returns the secant of an angle, measured in radians. Learn more.
Analisi dati
Apri schedaSECH
SECH(value)
The SECH function returns the hyperbolic secant of an angle. Learn more
Analisi dati
Apri schedaSEQUENCE
SEQUENCE(rows, columns, start, step)
Returns an array of sequential numbers, such as 1, 2, 3, 4. Learn more.
Analisi dati
Apri schedaSERIESSUM
SERIESSUM(x, n, m, a)
Given parameters x, n, m, and a, returns the power series sum a1xn + a2x(n+m) + ... + aix(n+(i-1)m), where i is the number of entries in range `a`. Learn more
Analisi dati
Apri schedaSIGN
SIGN(value)
Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero. Learn more
Analisi dati
Apri schedaSIN
SIN(angle)
Returns the sine of an angle provided in radians. Learn more
Analisi dati
Apri schedaSINH
SINH(value)
Returns the hyperbolic sine of any real number. Learn more
Analisi dati
Apri schedaSQRT
SQRT(value)
Returns the positive square root of a positive number. Learn more
Analisi dati
Apri schedaSQRTPI
SQRTPI(value)
Returns the positive square root of the product of Pi and the given positive number. Learn more
Analisi dati
Apri schedaSUBTOTAL
SUBTOTAL(function_code, range1, [range2, ...])
Returns a subtotal for a vertical range of cells using a specified aggregation function. Learn more
Analisi dati
Apri schedaSUMIF
SUMIF(range, criterion, [sum_range])
Returns a conditional sum across a range. Learn more
Analisi dati Finance
Apri schedaSUMIFS
SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])
Returns the sum of a range depending on multiple criteria. Learn more
Analisi dati Finance
Apri schedaSUMSQ
SUMSQ(value1, [value2, ...])
Returns the sum of the squares of a series of numbers and/or cells. Learn more
Analisi dati
Apri schedaTAN
TAN(angle)
Returns the tangent of an angle provided in radians. Learn more
Analisi dati
Apri schedaTANH
TANH(value)
Returns the hyperbolic tangent of any real number. Learn more
Analisi dati
Apri schedaTRUNC
TRUNC(value, [places])
Truncates a number to a certain number of significant digits by omitting less significant digits. Learn more
Analisi dati
Apri scheda