Questions tagged as 'excel'

Tagged questions
5
answers

Excel is a programming language?

No, no, I'm not asking for my opinion. I'm creating this because today I found this unlikely question: Is HTML a programming language? And, I confess, I voted positive in the second comment (image below) of the main answer: So t...
asked by 21.11.2015 / 20:56
7
answers

How to implement a linear regression algorithm?

I need to implement a linear regression algorithm. Preferably, it gives results that are the same as or close to the TREND (or TREND ) function of Excel. I have already found a lot of material that attempts to explain the whole concept of...
asked by 05.02.2014 / 17:26
1
answer

How to do a text break in Excel programmatically with a check in C #

I'm using Microsoft.Office.Interop.Excel to create an Excel report from a txt file. Everything works perfect, but sometimes some columns become extremely large and when we need to print, we need to resize and look horrible. When I t...
asked by 08.04.2016 / 20:11
2
answers

How to compare intervals?

I think it's not hard to do this, but I could not do it even though I tried to wonder if anyone could help me. In an Excel worksheet I have random numbers from A1 to A6 and would like to compare the sequences of the first two cells "A1: A2" w...
asked by 21.09.2015 / 16:52
2
answers

VBA / Excel Combobox: Disable Auto-Complete

I am typing a text that is in a ComboBox of VBA / Excel , but the initial part of the text matches another text already included in the list, which I do not want), it changes the position of the list (the index). Can you handle this? When...
asked by 24.11.2015 / 22:27
3
answers

Organize data in Excel to open as table in R?

I have a file with 50 comments and 3 variables in Excel (.xlsx) file, and I made it into .csv. I used banco1<- read.csv("teste1.csv") to create the table in R, but my 3 variables appear in the same column. How do I make them appear sep...
asked by 29.09.2014 / 05:19
2
answers

Formula to calculate numeric ranges in Excel

I need some help to make an Excel formula. =SE(C11<=6;"G4";SE(6<C11<=10;"G6";SE(10<C11<=16;"G10"))) What I want to do is: If the C11 cell is less than or equal to 6, type G4 . If the C11 cell is greater...
asked by 04.07.2014 / 16:40
2
answers

How to calculate direct treasury custody rate

Consider the following investment: Capital inicial (C) = 1000,00 reais Juros (J) = 12% ao ano Período (n) = 8 anos Taxa de Custódia (TC) = 3% ao ano The custody fee (TC) is a fee charged annually on the amount accumu...
asked by 05.11.2014 / 17:07
1
answer

VBA Macro fetch information on site

I need to search for information on a real estate site and bring it to excel. I made the macro below: Sub zap() Set ie = CreateObject("InternetExplorer.Application") With ie .Navigate "http://www.zap.com.br/imoveis/fipe-zap/" .Visible = True...
asked by 06.03.2014 / 18:29
1
answer

How to generate a full value in Portuguese in MS Office Excel?

In an Excel spreadsheet, having a cell with a numeric value, how to calculate its value in words? For example, in cell A1 I have the value R$ 587,32 . I need a function that passed the cell as a parameter, return the text:...
asked by 14.12.2013 / 16:35