How to insert multiple conditions in a formula? [Solved/Closed]

Report
Posts
14
Registration date
Sunday April 27, 2014
Status
Member
Last seen
September 29, 2014
-
Posts
14
Registration date
Sunday April 27, 2014
Status
Member
Last seen
September 29, 2014
-
I have 2 cells, and I proceed like this with a formula and basically, if cell A2 meets a condition, then cell B4 shows the word "Good"

=IF(A2>=1000,"Good","")

but if I want to elaborate with the following.....

=IF(A2>=2000,"Better","")
=IF(A2>=3000,"Best","")
=IF(A2>=4000,"Outstanding","")

What would the formula look like?

2 replies

Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
doublewitt, Good morning.

If you want to do this using a IF function, you can use this one:

B4 -->
=IF(A2=" ","",IF(A2>=4000,"Outstanding",IF(A2>=3000,"Best", IF(A2>=2000,"Better",IF(A2>=1000,"Good","")))))

But if you have a little table you can use a VLOOKUP function.
It's easier to control your parameters and a more organized way to your excel file.

........A................B............C.........D.............E..............
1..............................................Value......Result...........
2....4000..................................1000......Good
3................................................2000......Better
4...............Outstanting.............3000......Best
5................................................4000......Outstanting

Use this formula at B4:
=IFERROR(VLOOKUP(A2,D2:E5,2,TRUE),"")

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Posts
14
Registration date
Sunday April 27, 2014
Status
Member
Last seen
September 29, 2014

A big help --- Thank you

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!