Nested If Then Statement

Walle_PGE

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!

Paul Newcome

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))))