How to insert multiple conditions in a formula?

Solved/Closed
doublewitt Posts 14 Registration date Sunday April 27, 2014 Status Member Last seen September 29, 2014 - May 3, 2014 at 05:36 PM
doublewitt Posts 14 Registration date Sunday April 27, 2014 Status Member Last seen September 29, 2014 - May 4, 2014 at 12:24 PM
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

Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 146
May 4, 2014 at 09:11 AM
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
0
doublewitt Posts 14 Registration date Sunday April 27, 2014 Status Member Last seen September 29, 2014
May 4, 2014 at 12:24 PM
A big help --- Thank you
0