Excel, if Excel cell is X, Y or Z then display 1, 2 or 3

if cell equals one of multiple values
excel if cell equals a or b
excel if one cell equals another then return another cell
excel formula if cell contains text then return value in another cell
excel if cell contains text then display
if then excel
excel if x = y then z
excel if cell equals x

I need help with code for excel.

What I need is if a cell contains "Achieved" then display 1, "Partially Achieved" display 2 and if "Not Achieved" display 3.

Can someone help with what I need to enter?

Thanks

=IF(A1="Achieved",1,IF(A1="Partially Achieved",2,IF(A1="Not Achieved",3,"NA")))

Excel formula: If cell is this OR that, If you want to do something specific when a cell equals this or that (i.e.. you can use the IF function in combination with the OR function to run a test, then take one action In this case, we do that by adding an "x" to column D. If the test is FALSE, we the formula would actually display FALSE whenever the color is not red. If Cell is X or Y and Z. We can use a nested formula that combines the IF, AND, and OR functions to test for multiple conditions. Here, we will test if a cell value fulfills X OR Y conditions and Z CONDITION. The steps below will walk through the process. Figure 1: Result of If Cell is “Science” or “Arts” and “A”.

Try,

=iferror(match(A1, {"Achieved", "Partially Achieved", "Not Achieved"}, 0), "")

fwiw, to perform the reverse (with 1, 2 or 3 in a cell) use,

=iferror(choose(A1, "Achieved", "Partially Achieved", "Not Achieved"), "")

Excel, if Excel cell is X, Y or Z then display 1, 2 or 3, This post will give you an overview of how to combine IF, AND, OR functions. Here, we will test if a cell value fulfills X OR Y conditions and Z CONDITION. Figure 1: Result of If Cell is “Science” or “Arts” and “A” e.g. Cell E1 = 3 to show in new cell that row (H1) the letter "C" I have multiple rows with different values in​  If you want to do something specific when a cell equals this or that (i.e. is equal to X or Y, etc.) you can use the IF function in combination with the OR function to run a test, then take one action if the r esult is TRUE, and (optionally) do

=SWITCH(A1,"Achieved",1,"Partially Achieved",2,"Not Achieved",3)

Where A1 is the cell you want to check of course.

Excel IF statement with multiple AND/OR conditions, nested IF , If you're new to Excel for the web, you'll soon find that it's more than just a grid in which you Yes, you can use Excel for the web to find totals for a column or row of For example, the following formula multiplies 2 by 3 and then adds 5 to that result to 1. The AVERAGE and SUM functions are nested within the IF function. To count cells that contain either one value or another, you an either use a helper column then tally up the count, or a more complex single cell formula. Excel formula: Count cells that contain either x or y | Exceljet

For those without SWITCH (and half the length):

=MATCH(LEFT(A1),{"A","P","N"},0)

Excel formula: If cell is x or y and z, It covers Else, ElseIf, conditions and the alternative Select Case statement. 1 Quick Guide to the VBA If Statement; 2 The Webinar; 3 What is the VBA If For x = 1 To 5, Assignment, Set the value of x to 1, then to 2 etc. Cells(i, 4).Value ' Check if subject greater than 50 and less than 80 If subject If Left(Range(“A” & z). Excel: if cell 1 contains X or Y or Z, then cell 2 should equal W. As from the title, I need Excel to auto-populate the B row cells based on the corresponding A row cells content. So if cell A1 contains X or Y or Z, then cell B1 should equal W, or if A1 contains G or H or J, cell B1 should equal W.

Overview of formulas - Excel - Microsoft Office Support, The Rows have a list of Numbers in Column A (1, 2, 3, 4, 5, etc.) Each Number and Date corresponds to a value. So, for example: 12/1/2008 and 1 corresponds​  If you want to do something specific when a cell equals this or that (i.e. is equal to X or Y, etc.) you can use the IF function in combination with the OR function to run a test, then take one action if the r esult is TRUE, and (optionally) do something else if the result of the test is FALSE.

VBA IF Statement - A Complete Guide, This Excel tutorial explains how to use the Excel OR function with syntax and This website would not exist without the advertisements we display and your kind to write a formula to express if C2 is either 1,2,3,4,5,6,7,8,9 and F2 is F and F3​  How to return another cell if one cell equals text or another in Excel? For example, I have the following data range, now, I want to extract the values in column C if the corresponding data in column A equals adjacent data in column B as below screenshot shown.

If Cell 1 = X and Cell 2 = Y, then return Z, In this tutorial I show you some practical examples of IF AND and IF OR formulas. In Excel language on its own the AND formula reads like this: =OR(is condition 1 true, OR condition 2 true (add more conditions if you want) AND he earns <$100k), calculate his salary x 10%, if not put "Nil" in the cell). If Value in cell is between X and Y return Z Hi There, In one column I have a range of percentages and I would like to bucket the 20%s as 20%, and if the value is between 30 and 39% bucket it as 30% and so on.

Comments
  • IF function will work for you
  • Thanks @dbmitch but what would the formula look like, I have tried a few options, but get errors or no response
  • Post what you have tried. Edit your question to do that. Don't post that in a comment.
  • A simple switch would do the trick as well =SWITCH(A1,"Achieved",1,"Partially Achieved",2,"Not Achieved",3) Where A1 is the cell you want to check of course
  • @Zephire write this up as it definitely belongs up there with the other two answers, 'cos it will get +1 from me... Oh and let me know!
  • This is much neater than having lots of nested if statements.
  • Thank you @SolarMike. It was purposed to provide an avenue for future users (beyond referencing a lookup table when the choices become unmanageable).