title: Input a number and verify to a range
body: <p>I'm using excel, I want to input a number and verify it to a range. example my range is 86.1 +/- 1. I want to input a number and have it verify that its between the range. So if you type in 86.0 then you can continue, if you put 8.60 then it will prompt you. We have a lot of "fat fingering" going on, and I don't want to be able to continue if the input doesn't  fit in the range. I have no idea.....
  Is there a formula to do this in excel?</p>
  
  <p>I've tried using Fact and vlookup, but its not working</p>