IF - ELSE IF - ELSE Structure in Excel

0 votes
If the string in cell A1 contains "abc" as part of the string

Then assign value "Green"

Else if the string in cell A1 contains "xyz" as part of the string

Then assign value "Yellow"

Else

Assign value "Red"
Feb 18 in Others by Edureka
• 9,700 points
17 views

1 answer to this question.

0 votes

In this case, you can use nested if  statement, present in excel 
here you need to put the second statement under another if statement and the third statement under else statement 
since it is put inside another if, we call it nested if statement 

example where you would want to add medium in your size listing .then you need to put this extra if in the statement.

=IF(column number="S","Small",IF(column number="M","Medium","Large"))
answered Feb 18 by Edureka
• 8,820 points

Related Questions In Others

0 votes
1 answer

Want to compare two columns in excel

Hello To compare two columns in excel ...READ MORE

answered Feb 9 in Others by Edureka
• 8,820 points
27 views
0 votes
1 answer

Spell number in excel 2013 using 2 rows

Hello, there are a few steps to ...READ MORE

answered Feb 16 in Others by Edureka
• 9,700 points
49 views
0 votes
1 answer

Substring in excel

Hi Basically there is no specific formula ...READ MORE

answered Feb 16 in Others by Edureka
• 9,700 points
14 views
0 votes
1 answer

Language independent way to get "My Documents" folder in VBA Excel 2003

 Hello :)  This code may help you in your ...READ MORE

answered Feb 16 in Others by Edureka
• 9,700 points
18 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16 in Others by Edureka
• 9,700 points
32 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16 in Others by Edureka
• 9,700 points
17 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17 in Others by Edureka
• 9,700 points
21 views
0 votes
0 answers

MS Excel - SumProduct formula with Loop

1 I have 4 arrays of data where ...READ MORE

Feb 18 in Others by Edureka
• 9,700 points
22 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

If you need to test a condition, ...READ MORE

answered Feb 17 in Others by Edureka
• 8,820 points
9 views
0 votes
1 answer

Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE

answered Feb 9 in Others by Edureka
• 8,820 points
64 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP