All Questions
350
questions
1
vote
1
answer
51
views
Calculating total pay when hourly rates are different after 40 hours worked
I am trying to calculate the total pay based on hours worked. The rates are €12 for the first 40 hours, €15 for each overtime hour.
I have made the following sheet:
The hours worked are formatted as ...
- 15
0
votes
2
answers
82
views
Excel SERIESSUM won't accept array of cell references as coefficients
The Google Sheets version of "SERIESSUM" function accepts an array of cell references for the "list" of coefficients as in this example:
=SERIESSUM(O8549,0,1,{K8549,K8538,K8526,...
- 3
0
votes
0
answers
74
views
How to Sumproduct with SUMIFS from another sheet without making extra columns
I am trying to get the SUMPRODUCT (total specific cost) for projects (with employees' code and employees' cost, projects' code from a sheet and a sheet of working hours in month with employees' code, ...
- 1
2
votes
1
answer
86
views
Populate cell with value from 4 possible cells
I want to populate one cell based on the text value of one cell out of 4 possible choices. The other four cells will not have any values. Only one of the 4 will have a value I want to populate in the ...
- 21
0
votes
1
answer
469
views
Can anyone please tell me how can I convert 1M, 1B, 1K to number format in excel? [duplicate]
Can anyone please tell me how can I convert 1M, 1B, 1K to number format (like 1K = 1000) using formula in excel.
Advance thanks for help.
0
votes
1
answer
62
views
Format of Excel drop down list
When choosing from a drop down list in Excel, is it possible for the cells to change the format when you choose a specific subject?
Each subject has a different format for the cells.
- 1
0
votes
1
answer
54
views
count unique with multiple criteria, what should i do?
Problem
I want to count uniquely in multiple criteria but it seems the formula isn't working
The count should be 6 instead of 3.5
what should I do?
0
votes
2
answers
221
views
Index Function with error "You've entered too many arguments for this function"
=index(_70Rain,1+int((row(b4)-1/columns(_70Rain)),mod(row(b4)-1+columns(_70Rain),columns(_70Rain))+1)
I just followed the code given in https://www.extendoffice.com/documents/excel/1172-excel-...
0
votes
1
answer
487
views
In Excel my formula is skipping the first two cells of a table
Hi I have an Excel Spreadsheet and I'm trying to convert a table with multiple rows and columns into just one column for sorting and filtering. But the issue is that it doesn't start at cell A2 where ...
1
vote
1
answer
44
views
My IF function isn't working when I try to pull out a specific word
I am trying to have the cell populate if the word CAT|I is in a different cell. I am using the following function:
=IF(ISNUMBER(SEARCH("CAT|I,",F12)),"CAT I","NO")
...
- 11
0
votes
2
answers
153
views
Append string to an Excel-cell, but ignore appended value when referenced in calculations?
I am wondering if there is a way to append a cell with a string value (for better/readable presentation), but ignore this appended value in formulas when referenced?
For example, lets say
A4 has the ...
- 343
-1
votes
1
answer
53
views
Excel Count Different Values With extra if
I have a large amount of data. I want to count every different data. I've found that part of my formula but I want to add ab extra if; For example, I can count different data with this formula;
=SUM(...
- 1
0
votes
1
answer
616
views
Highlight all the cells if the keyword in the cell matches to any value of a list
For one of my excel sheet, it is required to highlight the cells that has specific keyword in it.
To solve this, i have created a list called my_list which contains value1, value2 & value3.
I have ...
5
votes
3
answers
583
views
Excel: Get range address from single input (looking for compact formula)
I'm trying to get an absolute range address from single input. Something like this.
Formula
=SOME.MAGIC(A1:B10)
Output (string)
"$A$1:$B$10"
Attempt 1
I'm able to get this result but using ...
- 885
0
votes
1
answer
6k
views
Excel: Drop down with month instances
Is there a possibility to have a drop down with months inside, when choosing one month to show me all instances that are within that month?
Something similar has Excel format Tables, when you choose ...
- 121