I need 2 formulae, one to find cells with values between 95s and 100s such as between 195 and 200, 295 and 300, 1195 and 1200 etc. and scond to find cells with values between 100s and 105s such as between 200 to 205, 1200 to 1205 etc.
Please note that the cell values will be in 2 decimal places, such as 195.94, 1195.30, 1205.30 etc.
The solution may please be checked with values such as 430.95, 150 etc. since I tried dividing the cell values by 100 and rounding off to zero decimal, but then excel treats values such as .30 as .3 and I was getting false results.