Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [worksheet-function]

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

0
votes
0answers
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
0answers
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
2answers
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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 ...

15 30 50 per page