Super User Stack Exchange
Super User Stack Exchange

Questions tagged [if]

52 questions
2
votes
2 answers

Excel MEDIAN across ARRAY with multiple conditionals using IF and AND functions

I want to determine a MEDIAN of values in one column based on meeting conditions in two other columns. I'm using MS Excel. I know I have to process the MEDIAN function as an ARRAY (ctrl + shft + enter) using an IF function, and this works fine if I…
theforestecologist
  • 586
  • 1
  • 9
  • 26
1
vote
2 answers

IF condition with partial match of an indexed VLOOKUP column - Excel

I have this sample of a spreadsheet to simplify what I'm trying to do: In "Formula 1" I'm using a VLOOKUP function within an IF condition to assign value_if_true (and value_if_false) whether the result of the VLOOKUP function, specifically each…
NorthSon
  • 127
  • 5
1
vote
3 answers

Excel 8 possible results with IF statement based on 3 inputs

Is it possible to turn the following result table into an IF statement? If not is there any other way to do this? I have tried many combinations using IF,AND and OR but i cant seem to get it right! Thanks for the help!
JonhDoe
  • 13
  • 3
1
vote
3 answers

IF statements excel help referring to multiple cells

I am struggling a bit with my IF statement and was wondering if I can get some help. I made a new column and want to have it filled based on three other cells. For example, you can see the attachment below. I want the new column to say, for example,…
Robert Wilson
  • 11
  • 1
1
vote
2 answers

Can we have multiple IF (3 to 5 conditions, if it start with 1z33 it's UPS if it start with 4455 it's fedex...) for one cell in Excel ? Pc Windows 11

Is it possible to have multiple IF for one Cell? example if leftA1 =4455,"Maro" if=5522, "John" and so on... I work in shipping and when I scan a product shipping label I need it to show the courier company/ Thank you
Mario Trad
  • 11
  • 1
1
vote
3 answers

Subtracting numbers in Excel - numbers in three columns, not all columns contain data, subtract latest data collected from earliest data collected

I have a spreadsheet which has a large number of rows. Each row has 3 columns (B,C,D) that can contain numerical data that has been collected at three different points in time. B = first time point, C = second time point, D = third time point. When…
Stephen Dodd
  • 11
  • 1
1
vote
0 answers

How do I keep the cell blank when the formula outputs nothing, so that the text from the previous adjacent cell can overflow in it?

I have a basic Excel IF function that shows a computation result if the condition is TRUE. What I am trying to figure out how is, in case the condition is FALSE, how to keep the cell blank so that text from the previous, adjacent cell can freely…
kaboom1
  • 3,027
  • 2
  • 14
  • 5
0
votes
1 answer

How can I do multiple IF conditions in MS EXCEL?

I am trying to assign multiple conditions to a cell in excel using the IF formula. What I want to achieve is that if the value of cell A is greater than 12000, but less than 75000, then the operation to be performed is to multiply the value of cell…
Edgar Dominguez
  • 1
0
votes
0 answers

My If function is not working to return data correctly

I have a worksheet full of data and I am trying to build a summary tab to put it in a format to view the information I need from the worksheet together. It is a fairly simple IF function. The first IF function works fine and returns the data…
Heather Ward
  • 1
0
votes
1 answer

What IF / OR formula in excel can calculate duration between a specific date and today, or between two specific dates?

I'm not sure if this is possible but here is what I would like to do if anyone knows a formula please. I want to show the duration (in weeks) that a Case is is/was open based on: a) between the Date Opened and TODAY (if Date Closed is blank) OR b)…
Eva
  • 1
0
votes
1 answer

Using Ifs and Min together, returning a different number depending on lowest value in a cell

I have a column that will contain several numbers (between 1-4) in each cell depending on answers from a survey. ie 1,2,3,4 or 3,4 or 1,2,3 In a separate column i need to have just one single number, which, because the answers escalate means that i…
myermano
  • 1
  • 1
0
votes
1 answer

Excel: If A does not contain column B then let Column C = A+B

I'm trying to clean up a sheet of about 4500 entries. I have some entries where the first and last name are in the same cell and some where they're not. Is there a quick way to say If B is not found in A then add the contents of A and B in…
H00pak
  • 1
0
votes
2 answers

Vlookup with Blank cell

Vlookup with Blank cell I have a Vlookup formula that I want to return "" if the value is empty.For example: =Vlookup(D2, sheet 1,A2:D2,3,0)
Iraj7280
  • 13
  • 1
  • 4
0
votes
2 answers

IF + ISNUMBER + SEARCH Formula

I am trying to create a formula that will enter specific texts, when the cell had certain keywords. I've seen a formula here, but I can't seem to add more texts to it. What should be my formula below? My formula doesn't seem to…
Pat
  • 5
  • 2
0
votes
0 answers

How can I combine two Excel formulas into one?

In a spreadsheet, I have five columns (total) and four of them have the components of the students' grade. The fifth has the final grade. Now, I need to combine two formulas so that when the four columns have the grades, the first formula executes…
Iraj7280
  • 13
  • 1
  • 4
1
2 3 4