Formula to add a number in a cell based on other figures

Petcheyd03

Screenshot 2022-12-15 at 16.17.05.png

Hi hoping for any help I can get on this.

Using the image as a reference.

Im trying to make [Length score] show a number between 1-4.

the scenario being if the length is 30 days or less it equals 1 and between 30-90 it would show a 2, between 90-150 show a 3 and between 150-365 show a 4.

Would love any help on this people ive tried too many times to make it work!

Thanks!

Paul Newcome

You should be able to use a nested IF like so:

=IF(Length@row<= 30, 1, IF(Length@row<= 90, 2, IF(Length@row<= 150, 3, IF(Length@row<= 365, 4))))