I have a length value that gets entered into my spreadsheet. If it is <=120 I want to populate a cell with the value of 1. If it is >120 and <=240 I want to populate that same cell with a value of 2. If the length entered is >240 I want to populate that cell with a value of 3. Can this be done with an If statement? If not, how?