Formula Contem Excel Ingles

SUM: =SUM(number1, [number2], [number3], ...)

AVERAGE: =AVERAGE(number1, [number2], [number3], ...)

MAX: =MAX(number1, [number2], [number3], ...)

MIN: =MIN(number1, [number2], [number3], ...)

IF: =IF(condition, [valueiftrue], [valueiffalse])

COUNT: =COUNT(value1, [value2], [value3], ...)

VLOOKUP: =VLOOKUP(lookupvalue, tablearray, colindexnum, [range_lookup])

INDEX: =INDEX(array, rownum, [columnnum])

MATCH: =MATCH(lookupvalue, lookuparray, [match_type])

CONCATENATE: =CONCATENATE(text1, [text2], [text3], ...)

LEFT: =LEFT(text, [num_chars])

RIGHT: =RIGHT(text, [num_chars])

MID: =MID(text, startnum, [numchars])

TODAY: =TODAY()

NOW: =NOW()

ROUND: =ROUND(number, num_digits)

ROUNDUP: =ROUNDUP(number, num_digits)

ROUNDDOWN: =ROUNDDOWN(number, num_digits)

CONCAT: =CONCAT(range1, [range2], [range3], ...)

SUBSTITUTE: =SUBSTITUTE(text, oldtext, newtext, [instance_num])