formula Questions
2
Solved
I have this simple formula in Cell A1
=10*Round(B1/10,0)
I know how to enter this in VBA, i simply write:
Range("A1").Formula = "=10*Round(B1/10,0)"
Now, what if I don't know ...
3
Solved
Sometimes I come up with long spreadsheet formulas, such as this one to create "data bars" using Unicode characters (addresses are relative to G3):
= rept("█"; floor(10 * F3 / max(F$1:F$999)))
&a...
Dorotheadorothee asked 21/7, 2016 at 15:14
8
Solved
I know this looks simple.
In a Google spreadsheet, I have a column where I enter time in one timezone (GMT)
And another column should automatically get time in another time zone (Pacific Time)
G...
Megasporophyll asked 22/1, 2016 at 12:31
6
Is it possible to do an array formula with index match:
e.g:
=arrayformula(if(len(A3:A),INDEX('SheetB'!E:E,MATCH(A3:A,'SheetB'!H:H,0))))
If not, is there a solution that doesn't involve google...
Melainemelamed asked 20/1, 2015 at 10:35
5
Solved
While trying to remove duplicate phone numbers from a relatively large list I recently combined, Google Sheets presented me with this error message:
There was a problem.
Your selection contains...
Mumps asked 6/7, 2019 at 14:59
18
Solved
I have copied from a website a series of hyperlinks and pasted them in a google sheet. The values show up as linked text, not hyperlink formulas, and are still linked correctly. For each row, I'm t...
Noellanoelle asked 5/2, 2016 at 18:10
2
I'm trying to use a formula to get a field populated with the word "false" in NetSuite, but currently when I use this I get nothing showing up. If I modify it slightly to say "null" or "blank" or l...
4
Solved
We have a shopping cart that is used in different places, therefore the tax is stored in a config file, presently in New Zealand it is 15%, so in the config file we are storing .15 but this number ...
Harebell asked 3/4, 2013 at 0:49
5
I want to get the set of years which pertain to a specific date, week of the day and month. There are possibilities that I can get various years from this pattern. Suppose Date is 15, Month is Augu...
2
Solved
In the last few months I've worked on a number of projects where I've used the glmnet package to fit elastic net models. It's great, but the interface is rather bare-bones compared to most R modell...
3
Solved
I want to display random courses (MBA, MSc) in OpenOffice Calc. I tried:
=RANDBETWEEN('MBA', 'MSc')
and
=RAND('MBA', 'MSc')`
but they don't work as desired.
Turnage asked 9/12, 2013 at 8:31
7
I am a beginner at C#. I am facing a problem while converting a string to a mathematical expression. I have a UI where user can create formula using random formula field. And in another UI user wil...
Maintopmast asked 13/2, 2014 at 9:58
8
Solved
The LibreOffice Calc (version 6.3.4.2) shows the definition of the formula in the cell instead of executing the formula and displaying the result. What affects the behaviour?
I am starting to use L...
Vallation asked 9/1, 2020 at 14:8
3
Solved
I haven't been able to find an answer to this question, largely because googling anything with a standalone letter (like "I") causes issues.
What does the "I" do in a model like this?
data(rock)...
Titicaca asked 12/6, 2014 at 19:26
6
Solved
I have to port an algorithm from an Excel sheet to python code but I have to reverse engineer the algorithm from the Excel file.
The Excel sheet is quite complicated, it contains many cells in whi...
3
Solved
R has a handy tool for manipulating formulas, update.formula(). This works nicely when you want to get something like "formula containing all terms in previous formula except x", e.g.
f1 <- z ~...
16
Solved
After reading the base64 wiki ...
I'm trying to figure out how's the formula working :
Given a string with length of n , the base64 length will be
Which is : 4*Math.Ceiling(((double)s.Length/3...
11
Solved
I have two numbers, the first, is the original price, the second, is the discounted price.
I need to work out what percentage a user saves if they purchase at the second price.
example
25, 10 = ...
4
Solved
I have a week number in Cell C13 and a year in Cell C14.
I am using the below formula to convert this into the Thursday of that week number's date:
=DATE(C14,1,-6)-WEEKDAY(DATE(C14,1,3))+C13*7
How...
5
i am bit new to hadoop. As per my knowledge buckets are fixed no. of partitions in hive table and hive uses the no. of reducers same as the total no. of buckets defined while creating the table. So...
2
I have two colors, c₀ and c₁. They have variable alpha, red, green and blue values: (a₀, r₀, b₀, g₀) and (a₁, r₁, b₁, g₁). I'm wondering if there is a simple formula for combining these colors to o...
Initial asked 6/3, 2015 at 14:12
3
Solved
5
Solved
I have looked all over and tried a bunch of different things and non are working.
I can get the error to show - but I also want a blank cell to return -.
Right now blank cells are returning 0.
...
5
Solved
I'm writing my first S3 class and associated methods and I would like to know how to subset my input data set in order to keep only the variables specified in the formula?
data(iris)
f <- Speci...
3
Solved
I am trying to find a proper way to calculate the scalar product of two ranges. For instance, the product of A1:A3 and B1:B3 would be A1*B1 + A2*B2 + A3*B3. Is there a good way to do this? Hardcodi...
1 Next >
© 2022 - 2024 — McMap. All rights reserved.