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 ...
- 1
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, ...
- 1
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
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) ...
- 127
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!
...
- 13
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)
- 13
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? ...
- 5
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 ...
- 13
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 ...
- 3
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 ...
- 1
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 ...
- 3
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
...
- 3
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,287
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 ...
- 11
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
- 1
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
- 1
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
...
- 1
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, ...
- 3
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, ...
- 471
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 ...
- 1
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 ...
- 3
-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 ...
- 5
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:
...
- 33
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 ...
- 1
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("...
- 5
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 ...
- 23
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 ...
- 11
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 ...
- 1
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 ...
- 19
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 ...
- 3
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 ...
- 1
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.
...
- 1
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 ...
- 1
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 ...
- 1
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 ...
- 1