Thank you for viewing my post.

I am trying to calculate a set of If calculation for one cell but can't seem to get it right.

If A1 is greater than 105 through 109.9 then I would like B1 to = 1. If it is greater than 110, then B1 should = 2
=IF(A1>105-109.9,1,IF(A1>110,2))


Thank you,
-Newb