All Questions
Tagged with worksheet-function spreadsheet
223
questions
4
votes
1
answer
3k
views
Numbers conditional formatting based on a different cell in the same row
I have a Numbers spreadsheet, with "quantity required" and "quantity in stock" columns, then each part is on a row. I'm trying to use conditional formatting to turn a cell yellow when # required = # ...
3
votes
3
answers
3k
views
Using VLOOKUP for multiple lookup values, then summing the outputs
Example:
I have a sheet listing the number of calories for various foods.
In another sheet I have a list of some of those foods to be used in a meal, and would like to calculate the total number of ...
3
votes
3
answers
9k
views
How to create an array of values in LibreOffice Calc?
I'm using LibreOffice 5.1.4.2 Calc and need to calculate the internal rate of return for a certain payment (say, in cell A1), a certain number of times (say, 100).
If I had the value repeated 100 ...
3
votes
1
answer
3k
views
Assigning rank in OpenOffice (or LibreOffice)
In OpenOffice (or LibreOffice), is there a way to rank rows?
For example, let's say you have a spreadsheet where cell A1=20, A2=30, and A3=10.
I want to B1 to get a value of 2, B2 to get a value of ...
3
votes
2
answers
5k
views
How do I make a random selection in a spreadsheet using more than one criteria
I have a spreadsheet created in OpenOffice (V3.3.0 in Windows 7 32 bit) that I use as a database of my DVD collection. After asking a question in SuperUser, I have it so it can pop up a random title ...
3
votes
1
answer
247
views
Filtering over merged downwards cells in MS Excel-2016
Note: This question has been asked back in 2010 on this site here. And yet, I would like to post it one more time, showing what I did and what didn't work. Besides, Excel has changed quite a bit since ...
3
votes
1
answer
74
views
libreoffice /open office calc - visualise formula
Let's say I have two alternatives in columns C,D like so:
row 6: sample size
row 7: sample mean
row 8: sample standard deviation
and then want to do a t-Test, which requires (amongst other things)...
3
votes
1
answer
782
views
Sum values in specific rows based on whether the row has a value that belongs to a range
Here's what I'm trying to do:
I have a table that has several metrics (example: revenue, cost, etc.) for about a hundred different accounts. I can't modify this sheet because it gets auto-updated by a ...
2
votes
4
answers
7k
views
How to calculate how much I've worked per day?
I'm having a problem when I try to calculate how much time I've worked per day by using an Excel formula. It returns valid results for when I've worked until 12:00 PM but if I passes it, values come ...
2
votes
3
answers
1k
views
How do you properly align average and standard deviation outputs in a spreadsheet?
I am not sure of the best way of formulating this question right now so I will use an example using random numbers. I start with values assigned to IDs, so that each ID can be n=1, n=2, ... etc
ID ...
2
votes
1
answer
968
views
How do I return a column value based on whether another column is within an array range - Libreoffice Calc
If I have a comparison array like so on sheet "A"...
Size
Min
Max
SM
0
99
MD
100
199
LG
200
999
...and on sheet "B" I Have...
Val
Size
50
??
250
??
150
??
...
...
How ...
2
votes
1
answer
1k
views
CONCATENATE cells in a column IF condition in other colum is met
Using Google sheets (or Excel if Google sheets can't do it). I'm trying to concatenate any cell in B column, if its corresponding A cell is "include". The columns are very long and therefore ...
2
votes
1
answer
206
views
Devising Excel Spreadsheet Formulas
I'm using Excel for the accounting purposes of a group venture, to keep track of our expenses, costs, payments, and balances.
Details of each expense are stored in columns A:J
Total costs and ...
2
votes
2
answers
106
views
What is { } used for in Microsoft Excel 2010?
I came across this function in one of my worksheets and wanted to know what the curly braces are used for.
Here is an example.
{=array(sheet1!a1,sheet2!a3,sheet2!a5,sheet2!a6)}
2
votes
2
answers
219
views
Creating an Invoice in Excel
I have only dabbled with Excel and not much in quite some time now.
I have an Excel Invoice laid out so Column A is a name of a job and each row in column A can be a different job.
Now column B ...