Questions tagged as 'excel'

Tagged questions
2
answers

Values of formulas do not match

I'm trying to make the Excel formula VF (future value) in PHP, however the values are not matched, ie in Excel is a value for the column and in the PHP calculation others leave values but almost identical values, from R $ 1.50 to R $ 3.00....
asked by 11.04.2017 / 00:36
2
answers

How to make PROCV function (excel) in javascript

How to do the Procv function of excel in javascript; Ex: I have a table with 2 columns (name and code) and I have a list with only names, I need to go through this list with names and bring the code corresponding to each name according to...
asked by 24.01.2017 / 17:49
2
answers

How to calculate time intervals in excel

I have a worksheet that tells me where a truck was at a certain time: DATA/HORA COD. REVENDA 24/1/17 0:50 1 24/1/17 0:51 1 24/1/17 0:53 1 24/1/17 0:54 1 24/1/17 0:56 1 24/1/17 0:57 1 24/1/17 0:59...
asked by 25.01.2017 / 14:57
1
answer

Macro Excel capture redirects of links [closed]

Is it possible to create a macro that copies me the redirects I have in links in cells A1:A100 ? For example in cell A1 I have www.pplware.com , but when we open this url I'm redirected to another url https://pplware.sap...
asked by 30.12.2016 / 10:34
1
answer

Excel VBA - How to use VLookup with Letters and Numbers to Delete Rows?

Hello! I'm experiencing great difficulty with a problem using VLookup in Excel VBA. First of all, I am not VBA expert but I have been able to use VLookup but I am not having the effect I would like. I will explain below with more detail the situ...
asked by 07.02.2017 / 15:59
1
answer

List returns only the last element

Hey guys, after a lot of work I got several xml tags to play in an Excel report. But when I populate the list with my object and step into the report only the last element is listed. I already made some System.out.println to show the elem...
asked by 06.05.2015 / 16:09
1
answer

Doubt in excel [closed]

I need the following formula: If salary lower than R $ 1399.12, calculate 8% If salary greater than R $ 1399.13 and less than R $ 2331.88, calculate 9% If salary greater than R $ 2331.89 and less than R $ 4663.75, calculate 11%.     
asked by 14.07.2015 / 22:16
2
answers

How to use the "PROCH" function of Excel to search values from the bottom up?

By default the "Proch" function searches only the top-down values, I want to do the reverse, search the values from the bottom up, I want to search for the "40-D" character by reference "Cod.prod", how do I proceed through the "Proch" function ?...
asked by 23.11.2018 / 16:38
1
answer

How do I include the weekends in the "= Diatrabalho" function and include additional holidays in Excel?

I have a start and end date of a timeline, I wanted to count the weekends in case the end date would be 11/11/2018, how to use the function: =DIATRABALHO(C24;E24;Tabela1[DATA]) To count on the weekends? Would it also be possible...
asked by 24.10.2018 / 21:23
1
answer

The 'Value' method of the 'Range' object failed

Good night, I have the following error:    The 'Value' method of the 'Range' object failed The full code is here: GhostBin Hair PrivateSubCommandButton2_Click()'''Botão"CADASTRAR" código para inserir as informações fornecidas na pl...
asked by 20.11.2018 / 01:20