I would like to get a specific entry when I have a range of numbers for example I would like to get in the result field "good" within range of the numbers "1-100" and "better" within "101-200"and "best" within "201-300" What calculation I should use? Thanks a lot for any help

Try something along the lines of =

Case (

Input ≤ 100 ; "Good" ;

Input ≤ 200 ; "Better" ;

Input ≤ 300 ; "Best"

)

You didn't say what the default result should be in case the number is outside of the 1 - 300 range; here it is "Good" for any number lower than 1 (incl. negative numbers) and nothing (an empty string) for any number higher than 300.