Nested If Then Statement
Greetings Smartheet Community,
This is my first time posting a comment to the forum for help. I am trying to setup a nested if then statement and reaching the relentless "unparseable" response.
Okay, so I have one column with about 500 rows, and each cell has a value inbetween 0 and 51. I am trying to classify these values into 5 groups  1,2,3,4 & 5, within a neighboring column.
I would like to do this efficiently, thus my attempt at a nested formula.
=IF(AND([ColumnA@row < = 6, "1" (Column A]@row <= 14, "2", [ColumnA@row] <= 22.4, "3", )[ColumnA@row] <=33, "4", [ColumnA@row] <= 51, "5")
Ranges I'm trying to create if then statements for:
1: 06
2: 6.01  14
3: 14 22.4
4: 22.4  33
5: 33 51
Key Questions:
 Do I need to put in a greater than clause in between nested statements?
Please help.
Thank you!
Answers

You have the right idea. There are just a few syntax issues. Try this:
=IF(ColumnA@row <= 6, 1, IF(ColumnA@row <= 14, 2, IF(ColumnA@row <= 22.4, 3, IF([ColumnA@row <= 33, 4, 5))))
Help Article Resources
Categories
Check out the Formula Handbook template!