Para utilizarmos bem as funções do MS Excel precisamos ao menos saber que existem e conhecermos onde as podemos aplicar.
O que segue são algumas destas que podemos utilizar extensivamente, agora com um pouco mais de conhecimento.
Tenham em mente que elas estão expressas em inglês, escolhi assim para que pudéssemos ter proveito delas tanto funcionalmente no MS Excel quanto na programação VBA. Sei que na maioria das empresas a instalação está em português, o que pessoalmente acho péssimo, nestes casos poderá procurar pela referência de como escrevê-la em Português.
Funções de Matemática e TrigonometriaABSReturns the absolute value of a numberACOSReturns the arccosine of a numberACOSHReturns the inverse hyperbolic cosine of a numberASINReturns the arcsine of a numberASINHReturns the inverse hyperbolic sine of a numberATANReturns the arctangent of a numberATAN2Returns the arctangent from x- and y-coordinatesATANHReturns the inverse hyperbolic tangent of a numberCEILINGRounds a number to the nearest integer or to the nearest multiple of significanceCOMBINReturns the number of combinations for a given number of objectsCOSReturns the cosine of a numberCOSHReturns the hyperbolic cosine of a numberDEGREESConverts radians to degreesEVENRounds a number up to the nearest even integerEXPReturns e raised to the power of a given numberFACTReturns the factorial of a numberFACTDOUBLEReturns the double factorial of a numberFLOORRounds a number down, toward zeroGCDReturns the greatest common divisorINTRounds a number down to the nearest integerLCMReturns the least common multipleLNReturns the natural logarithm of a numberLOGReturns the logarithm of a number to a specified baseLOG10Returns the base-10 logarithm of a numberMDETERMReturns the matrix determinant of an arrayMINVERSEReturns the matrix inverse of an arrayMMULTReturns the matrix product of two arraysMODReturns the remainder from divisionMROUNDReturns a number rounded to the desired multipleMULTINOMIALReturns the multinomial of a set of numbersODDRounds a number up to the nearest odd integerPIReturns the value of piPOWERReturns the result of a number raised to a powerPRODUCTMultiplies its argumentsQUOTIENTReturns the integer portion of a divisionRADIANSConverts degrees to radiansRANDReturns a random number between 0 and 1RANDBETWEENReturns a random number between the numbers you specifyROMANConverts an arabic numeral to roman, as textROUNDRounds a number to a specified number of digitsROUNDDOWNRounds a number down, toward zeroROUNDUPRounds a number up, away from zeroSERIESSUMReturns the sum of a power series based on the formulaSIGNReturns the sign of a numberSINReturns the sine of the given angleSINHReturns the hyperbolic sine of a numberSQRTReturns a positive square rootSQRTPIReturns the square root of (number * pi)SUBTOTALReturns a subtotal in a list or databaseSUMAdds its argumentsSUMIFAdds the cells specified by a given criteriaSUMIFSAdds the cells in a range that meet multiple criteriaSUMPRODUCTReturns the sum of the products of corresponding array componentsSUMSQReturns the sum of the squares of the argumentsSUMX2MY2Returns the sum of the difference of squares of corresponding values in two arraysSUMX2PY2Returns the sum of the sum of squares of corresponding values in two arraysSUMXMY2Returns the sum of squares of differences of corresponding values in two arraysTANReturns the tangent of a numberTANHReturns the hyperbolic tangent of a numberTRUNCTruncates a number to an integer
Tags: Function, Excel, Tips, functions, Math, trigonometry, matemática, trigonometria
Nenhum comentário:
Postar um comentário