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

## 1 answer to this question.

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