# Questions tagged [worksheet-function]

Questions about using in-cell functions/formulas in spreadsheet software.

**0**

votes

**0**answers

5 views

### Format a cell to fit the contents within it (excel)

I am attempting to format a cell within Microsoft Excel with an image in the cell, but when formatting the cell to fit the contents, it will not properly fit. I have a spreadsheet that instructs user ...

**0**

votes

**0**answers

10 views

### Formula to ignore or treat as empty a cell that contains another formula with no result?

I'm using Excel 2007
I have a Cell B14 which contains a formula getting data from a different worksheet and sometimes this formula may have no result.
I need a formula to ignore Cell B14 or treat it ...

**0**

votes

**2**answers

34 views

### VLOOKUP for a range of letters

I need to take a range of letters for example:
if the cell contains A, B, C, or D and fill a cell with P1.
If the cell contains E, F, G, or H fill a cell with P2.
If the cell contains I, J, K,or L ...

**-1**

votes

**0**answers

27 views

### Excel Formula referencing IFERROR with blank gives #VALUE error

I have come across an issue with using IFERROR to return a blank. When I have another cell referencing this blank one to SUM values I get a #VALUE error in that cell.
I assume it is because the "" ...

**0**

votes

**1**answer

34 views

### IF function with two logical tests

I need help with creating a formula with two logical tests. I got the first one but can't figure out how to include the second logical test.
My formula currently: If column E=S, I want Annual Salary ...

**0**

votes

**0**answers

35 views

### Formula across sheets dependent on value on each sheet to include or not in Apple iWork Numbers

I am tracking my options trading, and as each position can span multiple transactions over time, including across year boundaries, I track each position from start to close on its own Sheet. I name ...

**0**

votes

**1**answer

223 views

### How to make SUMIF only consider the first column of a range?

I have a spreadsheet with 11 columns (A to K). I want a SUMIF to look at column A and add up the values in column K so my range is A-to-K. However, there are figures in columns B through J that ...

**0**

votes

**1**answer

21 views

### How to multiply a row of values to a table with the same number of fields?

I have a row of value from A2:H2 and then I have a table of values from B7:E8 (both the table and row have 8 data points).
How do I go about multiplying them? Please see the bellow illustration:
+---...

**0**

votes

**1**answer

28 views

### Is it possible to merge 2 IFERROR formulas into 1?

I'm not sure if it's possible to merge 2 IFERROR formulas into 1. I created 2 combo boxes, in 1 sheet, one for upper and one for sole (footwear) but only "upper" appears on data field because the ...

**0**

votes

**2**answers

19 views

### EXCEL:What's a good replacement for SEARCH function that returns #VALUE! error

I have cells that contain text with the format: IVORY / RED
I'm using a LEFT function to extract the first text string like so:
=LEFT(AV1440, SEARCH("/",AV1440,1)-1)
Sometimes I run into a cell ...

**0**

votes

**1**answer

16 views

### Get the name of the column of a largest number in an Excel array?

I have a data set with numeric values, from which I need to get the name of the column in which is located the largest number, row by row. Please see below (I'm omitting the columns names for ...

**0**

votes

**0**answers

48 views

### Updating Excel worksheet

I want to use a data input worksheet to update another sheet in the same workbook. Using a command button that updates sheet2, I want the data from sheet1,cell G3 to move to sheet2. The placement of ...

**0**

votes

**1**answer

47 views

### Cell has text and number, but I need to count both

I have an excel database formatted in a calendar style for employee holidays and wages.
Sarah works the same shift pattern every week, so in the cell that relates to Monday, I have "8", for 8 hours ...

**-1**

votes

**1**answer

50 views

### How do I compare the values of two columns and output the value in the third column

I have three columns in excel, A, B and C. A and B have the same attribute, however A has more values in the dataset. For every unique row id in B there is a corresponding value of 1 or 0 in column C....

**0**

votes

**1**answer

29 views

### How to interpolate a general formula from a set of data in excel?

I am making an experiment and I got the following results as X and Y. I also draw them in excel and it seems they Y vs X as linear. How can I interpolate a general function F(X) so that I can get the ...