Formula to add a number in a cell based on other figures
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!
Help Article Resources
Check out the Formula Handbook template!