Excel If Functions with Multiple Conditions

0 votes

I need to create a formula that captures the following information:

  • If the value in C3 is 0 it needs to read 'Green',
  • the value in C3 is ≥1 but <500 it needs to read 'Silver',
  • the value in C3 is ≥500 but <1500 it needs to read 'Gold' and
  • if the value in C3 is ≥1500 then it needs to read 'Platinum'.

I have this formula worked out:

=IF(D3<500,"Silver",IF(AND(D3>=500,D3<=1499),"Gold","Platinum"))

But I can't figure out how to incorporate the 0 to equal Green.

Dec 12, 2022 in Others by Kithuzzz
• 27,740 points
50 views

1 answer to this question.

0 votes

Use this:

=IF(C3<=0,"Green",IF(C3<500,"Silver",IF(C3<=1499,"Gold","Platinum")))

I added <=0 just in case you have negative numbers. Without it, -1 will return Silver. 

answered Dec 13, 2022 by narikkadan
• 51,240 points

Related Questions In Others

0 votes
1 answer

IF function in combination with an Round function Excel

I'm not sure if it is a ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 51,240 points
121 views
0 votes
1 answer

Excel If field with rounding

Here's your formula. Assumes your cell containing ...READ MORE

answered Sep 27, 2022 in Others by narikkadan
• 51,240 points
120 views
0 votes
1 answer

Excel - IF Formula with a FIND

What about using mid() to see if ...READ MORE

answered Sep 27, 2022 in Others by narikkadan
• 51,240 points
108 views
0 votes
1 answer

Create unique rows in Excel with limited data to be used in multiple columns

This setup isn't readily generalizable, though since ...READ MORE

answered Oct 14, 2022 in Others by narikkadan
• 51,240 points
100 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, 2022 in Others by Edureka
• 13,640 points
205 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, 2022 in Others by Edureka
• 13,640 points
364 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, 2022 in Others by Edureka
• 13,640 points
165 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 22,940 points
144 views
0 votes
1 answer

Excel Formula with Nested IF/LEFT/AND Functions

Use this: =IF(SUMPRODUCT(--(LEFT(G3,1)={"1","2","3"}))>0,"998", ...READ MORE

answered Nov 21, 2022 in Others by narikkadan
• 51,240 points
129 views
0 votes
1 answer

Excel concatenate function with multiple conditions

Use this : =TEXTJOIN(", ";TRUE;IF((Table69[Spec]=$B$1)*(Table69[Sl ...READ MORE

answered Dec 10, 2022 in Others by narikkadan
• 51,240 points
72 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP