Formulas no Excel em Ingles

  1. SUM - SUM(range): Calculates the sum of a range of cells
  2. AVERAGE - AVERAGE(range): Calculates the average value of a range of cells
  3. COUNT - COUNT(range): Counts the number of cells in a range that contain numerical values
  4. MAX - MAX(range): Finds the highest value in a range of cells
  5. MIN - MIN(range): Finds the lowest value in a range of cells
  6. IF - IF(condition, valueiftrue, valueiffalse): Evaluates a condition and returns one value if it's true and another if it's false
  7. ROUND - ROUND(number, num_digits): Rounds a number to a specified number of digits
  8. VLOOKUP - VLOOKUP(lookupvalue, tablearray, colindexnum, range_lookup): Searches for a value in the first column of a table and returns a value in the same row in a specified column
  9. CONCATENATE - CONCATENATE(text1, text2, ...): Joins two or more text strings into one
  10. LEFT - LEFT(text, num_chars): Returns the leftmost characters from a text string
  11. RIGHT - RIGHT(text, num_chars): Returns the rightmost characters from a text string

Veja também mais Fórmulas com a letra F

Fórmulas que começam com:

Comentários