Excel If Functions with Multiple Conditions

Question

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.

Thanks for your help in advance.

BruceWayne · Accepted Answer · 2020-01-13 17:55:00Z

1

You can do:

=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. Also note that if C3 is empty/blank, it'll return Green still.

edited Jan 13, 2020 at 17:55

answered Jan 13, 2020 at 17:54

BruceWayne

23.5k16 gold badges75 silver badges126 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

BruceWayne Over a year ago

@Eogrus - Glad to help! If this works for you, you can flag it as The Answer by ticking the check mark left of the post.

Collectives™ on Stack Overflow

Excel If Functions with Multiple Conditions

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related