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
- How many if statements can you nest - Guide
- Excel data validation list from table multiple columns - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Excel date format dd.mm.yyyy - Guide
- If then statements in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
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