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 in-between 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: 0-6
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!
