Stack Overflow
Stack Overflow

Questions tagged [worksheet-function]

A worksheet function is represented by a keyword in an Excel formula that performs some action on input and returns output to the calling procedure, either a worksheet cell or another function.

A worksheet function is represented by a keyword in an that performs some action on input and returns output to the calling procedure, either a worksheet cell or another function.

Worksheet functions may be used in as well, returning output to a VBA function.

The tag should be distinguished from the tag. If your question is about specific functions and what they do, use the tag. If you are asking about a formula you've written that doesn't return the result you expect, use the tag.

Links:

1256 questions
172
votes
17 answers

Get the last non-empty cell in a column in Google Sheets

I use the following function =DAYS360(A2, A35) to calculate the difference between two dates in my column. However, the column is ever expanding and I currently have to manually change 'A35' as I update my spreadsheet. Is there a way (in Google…
MichaelS
  • 3,722
  • 5
  • 21
  • 29
131
votes
15 answers

IF statement: how to leave cell blank if condition is false ("" does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following formula is entered in C1 (for which the condition is false) for example: =IF(A1=1,B1,"") and if C1 is tested for being blank…
Mayou
  • 7,628
  • 15
  • 51
  • 91
123
votes
23 answers

Last non-empty cell in a column

Does anyone know the formula to find the value of the last non-empty cell in a column, in Microsoft Excel?
MichaelS
  • 3,722
  • 5
  • 21
  • 29
79
votes
9 answers

How to turn a string formula into a "real" formula?

I have 0,4*A1 in a cell (as a string). How can convert this "string formula" into a real formula and calculate its value, in another cell?
Cloaky
  • 935
  • 2
  • 9
  • 10
72
votes
12 answers

Excel Reference To Current Cell

How do I obtain a reference to the current cell? For example, if I want to display the width of column A, I could use the following: =CELL("width", A2) However, I want the formula to be something like this: =CELL("width", THIS_CELL)
Steven
  • 12,263
  • 24
  • 94
  • 137
56
votes
4 answers

Excel formula to get cell color

I would like to know if we can find out the Color of the CELL with the help of any inline formula (without using any macros) I'm using Home User Office package 2010.
Praveen
  • 1,199
  • 1
  • 10
  • 20
53
votes
6 answers

Concatenating date with a string in Excel

I have two cells in Excel. one has a string and the other one has a date. in the third cell I want to put the date and the string together. For example: A1 = "This " A2 = "03/03/1982" I want A3 to be: This 03/03/1982 when I try to put this in the…
Alex Gordon
  • 51,480
  • 273
  • 609
  • 976
49
votes
12 answers

Case Function Equivalent in Excel

I have an interesting challenge - I need to run a check on the following data in Excel: | A - B - C - D | |------|------|------|------| | 36 | 0 | 0 | x | | 0 | 600 | 700 | x | |___________________________| You'll…
Nic
  • 11,969
  • 7
  • 36
  • 41
49
votes
8 answers

Use string value from a cell to access worksheet of same name

I have 2 worksheets: Summary and SERVER-ONE. In cell A5 on the Summary worksheet, I have added the value SERVER-ONE. Next to it, in cell B5, I would like a formula that uses the value in A5 to display the value of G7 in the worksheet of the same…
KingBob
  • 732
  • 1
  • 6
  • 13
36
votes
3 answers

Convert date field into text in Excel

I have an Excel file which has a column formatted as date in the format dd-mm-YYYY. I need to convert that field to text. If I change the field type excel converts it to a strange value (like 40603). I tried the text function but it gives me Error…
brpaz
  • 3,453
  • 9
  • 44
  • 70
32
votes
7 answers

Get values from other sheet using VBA

I want to get values from other sheets. I have some values in Excel (sheet2) for example: A B C D - - - - 1 | 2 5 9 12 2 | 5 8 4 5 3 | 3 1 2 6 I sum each column in row 4. I'm working with these values in sheet2 but I want…
Apollon1954
  • 1,308
  • 4
  • 16
  • 32
32
votes
9 answers

How do I slice an array in Excel VBA?

What function can I use in Excel VBA to slice an array?
Lance Roberts
  • 21,279
  • 29
  • 106
  • 128
29
votes
3 answers

How can I substitute quotation marks in Excel with SUBSTITUTE formula?

I have worksheet where I need named ranges to correspond to the contents of another cell. The text in the cell is something like: Partitions w Studs 16" oc Named ranges cannot have spaces, or most importantly, special characters like ". So, the…
Excellll
  • 5,349
  • 4
  • 36
  • 53
25
votes
5 answers

XIRR Calculation

How do I calculate Excel's XIRR function using C#?
Hitusam
  • 255
  • 1
  • 3
  • 6
25
votes
4 answers

Converting a string to a date in a cell

I have 100.000 rows of data in Excel. Some of the fields are dates, but the fields in Excel are as text. I need these fields in number format including both dates AND time (e.g. 21.10.2011 13:10:50). Formatting the cells doesn't work because that…
Machman
  • 311
  • 1
  • 4
  • 11
1
2 3
…
83 84