How to insert multiple conditions in a formula?
Solved/Closed
doublewitt
Posts
14
Registration date
Sunday 27 April 2014
Status
Member
Last seen
29 September 2014
-
3 May 2014 à 17:36
doublewitt Posts 14 Registration date Sunday 27 April 2014 Status Member Last seen 29 September 2014 - 4 May 2014 à 12:24
doublewitt Posts 14 Registration date Sunday 27 April 2014 Status Member Last seen 29 September 2014 - 4 May 2014 à 12:24
Related:
- Excel formula multiple
- Formula to calculate vat in excel - Guide
- Grade formula in excel marksheet - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel mod apk for pc - Download - Spreadsheets
2 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
4 May 2014 à 09:11
4 May 2014 à 09:11
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 27 April 2014
Status
Member
Last seen
29 September 2014
4 May 2014 à 12:24
4 May 2014 à 12:24
A big help --- Thank you
