Multiple IF statements in Excel
Solved/Closed
nesto2008
Posts
1
Registration date
Sunday July 15, 2018
Status
Member
Last seen
July 15, 2018
-
Updated on Jul 17, 2018 at 11:27 AM
Nesto2008 - Jul 17, 2018 at 11:20 AM
Nesto2008 - Jul 17, 2018 at 11:20 AM
Related:
- Multiple if statements in excel data validation
- Display two columns in data validation list but return only one - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- How many nested if statements in excel - Guide
- Number to words in excel - Guide
- Tmobile data check - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Jul 17, 2018 at 11:18 AM
Jul 17, 2018 at 11:18 AM
Hi Nesto,
Try this:
=IF(AND(A1>=1;A1<=10);10;IF(AND(A1<=11;A1>=20);11;IF(AND(A1>=21;A1<=30);12;"Not defined")))
Best regards,
Trowa
Try this:
=IF(AND(A1>=1;A1<=10);10;IF(AND(A1<=11;A1>=20);11;IF(AND(A1>=21;A1<=30);12;"Not defined")))
Best regards,
Trowa
Jul 17, 2018 at 11:20 AM