# Questions tagged [if]

The tag has no usage guidance.

51 questions
Filter by
Sorted by
Tagged with
42 views

### 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 ...
31 views

### 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 ...
41 views

### 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 ...
36 views

### 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, ...
23 views

### 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 ...
1 vote
91 views

### 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) ...
1 vote
66 views

### 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! ...
1k views

### 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)
174 views

### 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? ...
38 views

### 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 ...
90 views

### Excel formula to execute something if a cell has a value, if not, check for another cell's value

I have an excel file, that has the following information Name Type Type 2 Date Date 2 Ron A 1;2 Jon A 2;3 I'm trying to extract just the 1, and just the 2 in the Date, or 2 or 3 in Date 2 ...
114 views

### Excel formula - 2 out of 3 conditions met

I need help with producing a formula in Excel where 2 out of 3 conditions met and then have it perform a calculation accordingly. Example below If Cell =“certain text” and either “option1” or “option ...
35 views

### IF formula produces error when inserting new line

I am wondering if I could get some help with the below formula. Trying to add to an original IF statement but when our team adds to it we have too many arguments error. Any guidance is greatly ...
49 views

### IF test combining 2 cell

I am a casual user of Excel supporting my daughters ETSY business . Periodically I have to modify formulas and after trying several options require assistance. I am stuck with what I think should be ...
2k views

### Excel: IF all cells equals to one of two values, true, false

I need help with a formula in excel. The problem goes as this: I have 5 cells that will have one of three values: Yes, No and N/A. I tried creating a formula that shows “TRUE” if all these cells have ...
40 views

### Fill a cell with text & find match of a reference cell from previous entries, then automatically fill the respective "semi-adjacent" cells with a word

I am doing a daily task list excel sheet containing columns titled Month, Day, Task, Status, and Update. Cells under Status have a dropdown list choice of either "done" or "missed",...
52 views

### I need the next letter to return, if it is Z, return A

I need the next letter to return, if it is Z, return A The formula I'm using is this: =IF(CHAR(CODE(MID(Col_Ref!\$E2,2,1))+1)>90,CHAR(65),CHAR(CODE(MID(Col_Ref!\$E2,2,1))+1))
1 vote
57 views

### 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 ...
284 views

### Extensive nested IF, ISNUMBER, MATCH

= IF(ISNUMBER(MATCH(A26;B\$14#;0));A26; IF(ISNUMBER(MATCH(A\$36;B\$14#;0));IF(ISNUMBER(MATCH(A\$36;B\$26:B26;0)); IF(ISNUMBER(MATCH(A\$37;B\$14#;0));IF(ISNUMBER(MATCH(A\$37;B\$26:B26;0)); IF(ISNUMBER(MATCH(A\$...
121 views

### Excel: How do I compare 4 columns with repetitions?

I have 4 columns. A,B,X,Y. How do I compare all 4? I want to create column Z where if A == X and the corresponding value B == Y, the result is 1. It is zero otherwise, how do I do that? Thanks A B X ...
7k views

### windows batch. Checking for a substring in variable gives error. Needs Escaping for space

From https://stackoverflow.com/questions/7005951/batch-file-find-if-substring-is-in-string-not-in-a-file, I figured how to check if PATH variable has a certain substring(groovy's path). However, my ...
1 vote
31 views

### 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 ...
29 views

### Excel Formula IF and IFERROR

enter image description here Hi Everyone, I wondering what am I doing wrong here, why is I4 showing WIN when H4 is blank? I had to use IFERROR on H4 to avoid #div/0. Thank you, Ali
36 views

### How to copy paste cells using formulas

I want the excell to recognize if it is electrical or civil or plumbing and re-arrange the value in order
2k views

### 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)...
2k views

### formula to autofill with condition and skip blank cells

I have the master sheet and data sheet (more than 1 but same format) This is the example of the data from the sheet Project (Column C) Details (Column E) Project A Laptop Printer Camera blank ...
1k views

### CMD - Manually enter a value and check if it exists in a .txt with multiple lines > reply the result

I am trying to create a batch file which will check a given term against an existing text file with multiple lines (10000+ lines). More specifically, I have a list of domains that I want to blacklist, ...
30 views

### Excel nested "IF" returning "FALSE" but I cannot work out why

I want to do something quite simple in Excel: If Y13 is greater than 0% of X13 and less than 33% of X13, display "Strong". If Y13 is greater than 67% of X13 and less than 100% of X13, ...
85 views

### Nested IF statements with AND or OR

I have a schedule that calculates total hours worked for the week and also calculates the number of employees present at opening and at closing. The schedule is set up with nested IF statements to ...
25 views

### Value based on whether a column equals a constant

I have a list of values "New, Pending, Confirmed" and columns: date and details. I would like to calculate: x= IF details="New" THEN get(date) y= IF details="Pending" ...
27 views

### Is anyone having problems with the If function in Excel? It keeps automatically moving where I want to put my )'s

I am typing a similar formula to =if(a1="No","Not Applicable",'Data'!a3). But when I get to the A3 Excel automatically moves my cursor to just after the e" and wants to enter ...
76 views

### Excel multi layer if vlookup and formula

I've produced a simplified document that shows the essence of what I'm trying to achieve. The image of the document: There are 5 shops that all stock Apples, Pears, Bananas, and Oranges. Internally ...
166 views

### Excel formula gives error - 'You entered too many arguments' - IF function

I have a tier pricing first 10 units @ \$100 next 15 units @ \$50 and any further units @\$25 For example for 7 units the cost is \$700. For 11 = \$1050 and for 30 it should be \$1875 I tried to put the ...
56 views

### IF+AND function

I have to check if the value in C2 is in the column F, IF it is AND the last digit of C2 is "1", I want it to return as "Incorrect Variant" or blank. How do I write the correct ...
73 views

### Using a wildcard in a condition to match reading of a file

I have a file with patterns like: house car mous* So I would like to read these pattern's file and then do a comparaison and if the comparaison contains the patters gives me a message like these: ...
425 views

### How to select cells and subtract the numbers in the cells only when they match certain conditions

I'm creating an inventory management spreadsheet for my food business and I'm stuck with how to use IF, MATCH, or whatever formulas are appropriate to do this. Specific scenario: If a cell in the ...
93 views

### Combining an Excel IF Statement with VLOOKUP

I have the following if statement in Excel: =IF(VLOOKUP(AB2,AD:AD,1,0)=TRUE,1,0) What I am trying to do is say the following: "If the results of the VLOOKUP return any value other than "#N/...
30 views

### I am getting value error on find in mid

I am having Value error with this formula \$H\$5 cell value: 78th when the cell value is: 78rd formula drops correct value but when cell value is 78th it drops Value error. =IF(MID(\$H\$5;FIND("...
37 views

### Linux: test expression

How to use test to test a expression like this: if { [ \$month -eq 03 ] || [ \$month -eq 10 ]; } && [ \$weekday = "So" ] && [ \$day -gt 24 ] I need to test the whole if ...
34 views

### Fillup cell depending on value of another cell

So I want to fill up certain cells with certain values. I want to use the IF function. I have the following data: 4271423/421424/4237168/4246332=D917/F222 4271423/421424/4237168/4253485=D917/F222/J008 ...
1 vote
73 views

### 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 ...
602 views

### Access: How to use IF function to fill out the specific column based on the value from another column

In Access database, one column is Asset Value that is currency format or it could be numerical, and second column is Insured that is CheckBox or it could be a text format. I have to create code that ...
1k views

### Identify non-duplicates and copy to new column on Excel

I have a set of two columns. Column F has a list of names of scheduled attendees. Column C uses Match & Index to pull up attendees name when they scan their badge onto column A. I am interested in ...
380 views

### IF FORMULA FOR EXPIRE-NEAR EXPIRE AND FRESH

Hope you all are doing well. I need a formula for one of my sheets having data of different medicines. I have to bifurcate products by their expiry status. Fresh, Near Expired, Expired. Here I get to ...
113 views

### attempting Pass or Fail result based on a several cells meeting numeric criteria. "too many arguments for this function"

Here is the IF statement that is generating the error: =IF(B3<=B2, "Pass","Fail", IF(D2>=0, "Pass","Fail", IF(E2>=1,"Pass","Fail", ...
292 views

### IF statement pertaining to a SUM formula

I have created a spreadsheet that has a series of questions and an applicable drop down list beside each question with an appropriate numeric rating (e.g. 0, 1, 2, 3, 4 or 5). I have put in a formula ...
24 views

### Too many arguments to function excel, Budget Calculator

I am creating a budgeting tool which will use billing as weekly, monthly and quarterly drop-down boxes, and by selecting the drop-down box it calculates the monthly value in the next column over. ...
73 views

### If function result not the expected value

I'm very new at this and was wondering why my code is not working: =IF(LEFT(A16, 5)="B", "yes", "no") A16 is written as PD41B1 -- which should return a yes, but it only ...