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
doublewitt Posts 14 Registration date Sunday April 27, 2014 Status Member Last seen September 29, 2014 - May 4, 2014 at 12:24 PM
Related:
- How to insert multiple conditions in a formula?
- How to insert a checkmark in word - Guide
- How to insert @ in a laptop - Guide
- How to insert a line in word for resume - Guide
- Date formula in excel dd/mm/yyyy - Guide
- How to insert watermark in word - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
May 4, 2014 at 09:11 AM
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
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
doublewitt
Posts
14
Registration date
Sunday April 27, 2014
Status
Member
Last seen
September 29, 2014
May 4, 2014 at 12:24 PM
May 4, 2014 at 12:24 PM
A big help --- Thank you
