Essentially I have a calculator. This calculator produces values in 1 box. These values can vary and so I want to have set number ranges to categorise the results.
With this said, I want a function that takes the value from this box, evaluates what ranges it falls in, then returns a final value based on the range it falls in.
E.g. I want to have number ranges, counted in 30s so we have 301-330, 331-360 and 361-390 and so on.
Each range is assigned a number, 301-330 is 3, 331-360 is 2 and 361-390 is 1.
When a value is produced in this cell, it needs to be assigned a number, based on which range it falls in.
E.g. I get the number 385, so it falls in the range 361-390. Because it falls in this range, it is assigned the number 1.
I am at a loss on how to do this.
So far I have used this:
=COUNTIFS(AA6,">361",AA6,"<390")*1
This works, but when I try to repeat it to include other categories, it tells me I have too many arguments or asks me to add an apostrophe despite all the language being correct?
Any help be appreciated.
With this said, I want a function that takes the value from this box, evaluates what ranges it falls in, then returns a final value based on the range it falls in.
E.g. I want to have number ranges, counted in 30s so we have 301-330, 331-360 and 361-390 and so on.
Each range is assigned a number, 301-330 is 3, 331-360 is 2 and 361-390 is 1.
When a value is produced in this cell, it needs to be assigned a number, based on which range it falls in.
E.g. I get the number 385, so it falls in the range 361-390. Because it falls in this range, it is assigned the number 1.
I am at a loss on how to do this.
So far I have used this:
=COUNTIFS(AA6,">361",AA6,"<390")*1
This works, but when I try to repeat it to include other categories, it tells me I have too many arguments or asks me to add an apostrophe despite all the language being correct?
Any help be appreciated.
