6 funciones do Excel que seriam úteis para você saber antes

1. Search Function (PROCV): The PROCV function allows you to search for values within a table or range. Here's an example of its usage:

- Function: `=PROCV(value_to_find; table_range; column_number; [exact match])`

- Explanation:

- `value_to_find`: This is the value you are searching for.

- `table_range`: This is the range where your search is taking place.

- `column_number`: This tells Excel which column to look at for the search results.

- `exact match` (optional): If set to TRUE, the function will only return exact matches, otherwise it returns approximate matches as well. Default value is FALSE.

For example, if you want to find the price of product 302 in a range A2:C5, you can use the following formula: `=PROCV(302; A2:C5; 3)`

2. Replace Function (SUBSTITUIR): The SUBSTITUIR function allows you to replace specific text within a given cell or range of cells. Here's an example of its usage:

- Function: `=SUBSTITUIR(original_text; old_text; new_text; [occurrence])`

- Explanation:

- `original_text`: This is the cell or range you want to replace text in.

- `old_text`: The specific text that will be replaced.

- `new_text`: The new text that you want to use as a replacement.

- `occurrence` (optional): If set, it specifies the exact occurrence of the old_text to be replaced. Default value is ALL (replace all occurrences).

For example, if you want to replace all instances of the word "boa" with "bom" within a range A1:A32, use this formula: `=SUBSTITUIR(A1:A32; "boa"; "bom")`

---

🔗 Leia na fonte original