Question: how to create a less than formula in excel?
Answer: For example, the formula =IFS(A1 < 5, 1, A1 < 10, 2, A1 < 15, 3, A1>=15, 4) will populate the cell with "1" if the value in A1 is less than five, "2" if it's otherwise less than 10, "3" if it's otherwise less than 15 and "4" otherwise.