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 343 views

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.

• 63,720 points

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

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

IF function in combination with an Round function Excel

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

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

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

Convert Rows to Columns with values in Excel using custom format

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

IF - ELSE IF - ELSE Structure in Excel

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