Most voted "fórmula" questions
24 questions
Sort by count of
-
5
votes5
answers32003
viewswhat formula do I make for ranges of values in excel?
I need a formula in excel that identifies ranges, e.g. 0-30 = 20% 31-60 = 98,5% 61-90 = 100% 91-120 = 101,5% if f2<= 30 inform 20%; if f2>30 and <60 inform 98,5%, etc. How do I do?…
-
4
votes2
answers48
viewsHow to pass Corner Blob effect to right side of the screen?
I would like to reverse the effect demonstrated by starting from the right side of the screen and expanding to the left side, however, I did not achieve this. Someone could give me a light? const…
-
3
votes1
answer29901
viewsExcel formula to search part of the text in a table
I have a table of banks and codes in two columns. Ex.: Banco do brasil S/A 001 Banco do Estado do Rio Grande do Sul - Banrisul 041 Banco Santander do Brasil 033 Banco Mercantil do Brasil 208 Banco…
-
3
votes1
answer62
viewsExcel with Conditional Formula per month
I have this formula in the calculation column in the table: =+(K5+L5)*(1+8%) working! I changed the conditional calculation per month, example:…
-
1
votes2
answers508
viewsSearch in Table of Values in excel
Hello! I’m doing a cost chart for my company and I’m needing to do a search on a value chart, but the only way I currently know how to do it is through various chained Ses, which will take a lot of…
-
1
votes2
answers242
viewsSplit date format
I have the following value 14/02/2018 13:53:12 in excel. Cell with value is in text format. When having concatenate the value the date above is like this: 43145,57861111111 Does anyone know how to…
-
1
votes0
answers60
viewsHow to get Excel formula in C# using Oledb?
I need to get the formula contained in an Excel cell. I am using Oledb to access the spreadsheet, I wonder if you have how to use it to access the formula of a cell?
-
1
votes0
answers330
viewsscript to insert formula
Well, I’ve come up with a script to check if a column contains a formula, and if it doesn’t, it inserts. I’m doing this because every time I fill out a form, the formula that was before in the cell…
-
1
votes1
answer72
viewsSE function with 3 final values
---Rephrasing the question--- A formula expressing the following information: -When Column I and J is written "Letter N" will return in column C the writing "PSI" -When Column K and L is written…
-
0
votes1
answer113
viewsPrevent the PROCV formula from returning an error
Is there any configuration in Excel or some way to make the PROCV formula, when it does not find the searched value, return empty ("") or 0 instead of the error "#N/A"?
-
0
votes1
answer522
viewsZebra pattern in libreoffice
In Libreoffice Calc, I want to separate in a list of artists and titles, the artists by means of a different color. That’s the result I wish: As you can see, I wish in column C a formula to indicate…
-
0
votes2
answers72
viewsExcel Formula for formatting tables
Is there a formula for chaining the colors of a table? I don’t want "normal" (e.g. red|white|red). What I want is whenever the name of a given cell is equal, then the background is color A, when the…
-
0
votes2
answers429
viewsDoes Excel convert Macro into formula?
Without using the macro editor in VB it is possible to use a simple macro line in a formula? I want to get a value of a cell always from the tab to the left of the active tab, as this could be done…
-
0
votes2
answers1830
viewsExcel - How to concatenate cell range?
How do I concatenate a range of cells in Excel? For example: I have a column with many cells containing text information and I would like to concatenate them, but when using the concatenate function…
-
0
votes1
answer89
viewsFormula SE + PROCV ending in #VALUE!
Guys good afternoon. The formula below is ending in error #WORTH!. The formula is comparing words with hyphenation, I don’t know if it influences anything. =SE(PROCV(R25;'TABELA1'!A:A;1;0);"ERRO DE…
-
0
votes1
answer83
viewsHow to change position values for a given resource?
Another Hardcore challenge, I don’t know if I can explain it well, but here it comes. In the table below, I have the resource "X", where he has already made 8 contacts( 5 completed and 3 not…
-
0
votes1
answer404
viewsVLOOKUP function does not work in Excel
I’m making formulas in Spreadsheets Google, but when making a conditional formatting is stating that the formula is incorrect. =VLOOKUP(C3; Concursos!C3:H5; 1; FALSE) All cells contain whole…
-
0
votes1
answer104
viewsHow to add days in a date with the format dd/mm/yyyy in powerapps?
I’m taking a date from a table and adding days on the count in powerapps. Apparently on the computer works, but when I use the powerapps app on the phone doesn’t work, the date comes changed,…
-
0
votes2
answers46
viewsSE - Excel function
Good afternoon! I’m having trouble making a field true or false but with 3 variables. If A1 and B1 = "N" will be Null If only A1 = "N" will be True If Only B1 = "N" will be False How can I mount a…
-
0
votes1
answer59
viewsInsert Formula Matrix in Excel, via C#. ? (If you insert directly through excel, I have to give Crtl - Shift - Enter) - How to do this command with C#?
The following Code inserts a Formula into a cell in Excel. Based on the Spreadsheet "DATA", AND According to the column beside. However, this formula is a Matrix Formula, which in Excel needs to be…
-
0
votes1
answer17
viewsGenerate list in another tab with found data
all right? I am a beginner in excel and need your help to create a spreadsheet that generates a list in another tab based on the found result. When I set a date, I need you to copy the corresponding…
-
0
votes2
answers40
viewsUsing formula in SQL
Hello, I’m having a doubt and I can not find examples to progress, following: select 'disponivel' as TIPO , COUNT(distinct dp.ds_nome) as qtd FROM dm_pessoa_treino dp union ALL select 'em_uso' as…
-
-1
votes1
answer28
viewsCapturing values with multiple conditions in excel
Below is the link to a Google Sheets file that I need your help with: https://drive.google.com/file/d/1ejSffpo56lGFTRHTmueysF3WFZOIP2dO/view?usp=sharing There are 2 spreadsheets in this file, the…
-
-3
votes1
answer25
viewsAssign formula to a cell in VBA - Appears a @
I am learning VBA and in a sub where I try to assign the command below: =PROCX([@[Empresa Emitente]];FORNECEDORES[Empresa Emitente];FORNECEDORES[DEPART];"";0;1) Sub EXTRAIR_DEPART_UPDATE() Dim…