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
• 38,010 points
235 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
• 63,420 points

Related Questions In Others

0 votes
1 answer

How to use COUNTIFS with multiple conditions and columns in Excel?

Use  SUMPRODUCT and double unay operators: =SUMPRODUCT ...READ MORE

answered Apr 4, 2023 in Others by Kithuzzz
• 38,010 points
264 views
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
• 63,420 points
2,264 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
• 63,420 points
505 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
• 63,420 points
474 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,670 points
1,025 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,670 points
1,337 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,670 points
655 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
• 23,260 points
2,152 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
• 63,420 points
564 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
• 63,420 points
374 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