Questions tagged as 'formula'

I have the following value 14/02/2018 13:53:12 in excel. Cell with the value is in text format. When you concatenate the value the date above looks like this: 43145,57861111111 Does anyone know how to solve it? The func...

Well, I've booted a script to check if a column contains a formula, and if it does not contain it, it inserts it. I'm doing this because every time I fill out a form, the formula that was before in the cell disappears. Soon, the script will run...

How do I concatenate a range of cells in Excel? For example: I have a column with many cells containing text information and would like to concatenate them, but when using the concatenate function error occurs, being necessary to select one b...

Good evening, good evening. The formula below is ending in #VALOR! error. The formula is comparing words with a hyphen, I do not know if that influences anything. =SE(PROCV(R25;'TABELA1'!A:A;1;0);"ERRO DE WORKFLOW";"")     

Another Hardcore challenge, I do not know if I can explain it well, but there it goes. In the table below, I have the "X" feature, where he has already made 8 contacts (5 completed and 3 unfinished) and I would like to automatically count which...

Hello Use the formula = SE (SEARCH ("METHODS"; J28); "METHODS"; "OTHER") to locate certain texts in a column, but I could not put more than one conditional to have all the answers in a single column, I had to make a column for every text I'm...