# Questions tagged [if]

The if tag has no usage guidance.

51
questions

0
votes

1
answer

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 ...

0
votes

0
answers

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 ...

0
votes

1
answer

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 ...

0
votes

1
answer

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, ...

0
votes

1
answer

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

2
answers

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

3
answers

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!
...

0
votes

2
answers

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)

0
votes

2
answers

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? ...

0
votes

0
answers

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 ...

0
votes

2
answers

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 ...

0
votes

2
answers

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 ...

0
votes

1
answer

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 ...

0
votes

0
answers

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 ...

0
votes

3
answers

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 ...

0
votes

1
answer

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",...

0
votes

2
answers

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

3
answers

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 ...

0
votes

1
answer

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$...

0
votes

1
answer

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
...

0
votes

1
answer

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

2
answers

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 ...

0
votes

2
answers

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

0
votes

1
answer

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

2
votes

2
answers

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)...

0
votes

1
answer

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
...

0
votes

1
answer

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, ...

0
votes

1
answer

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, ...

0
votes

1
answer

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 ...

0
votes

0
answers

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" ...

0
votes

1
answer

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 ...

0
votes

2
answers

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 ...

0
votes

3
answers

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 ...

-1
votes

2
answers

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 ...

0
votes

1
answer

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:
...

0
votes

1
answer

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 ...

0
votes

1
answer

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/...

0
votes

1
answer

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("...

0
votes

0
answers

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 ...

0
votes

1
answer

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

3
answers

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 ...

0
votes

1
answer

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 ...

0
votes

2
answers

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 ...

0
votes

1
answer

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 ...

0
votes

1
answer

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", ...

0
votes

2
answers

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 ...

0
votes

1
answer

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.
...

0
votes

2
answers

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 ...

0
votes

0
answers

36
views

### Too many arguments with IF (another one!)

I have a very complex set of arguments. I can get my spreadsheet to partially work but not fully and have to use an additional column and make manual adjustments. If anyone could help me just have a ...

0
votes

2
answers

2k
views

### return yes or no based on cell data from another sheet

I have two sheets.
The first sheet "Example A" and the second sheet "Example B".
Example A has a master sheet of clients that may also be on Example B. If the client is listed on ...