counting between numbers

Is there a formula that counts all the numbers in between 1 and 2, up to two decimal places, but only shows the two numbers - 1 and 2 in the cell??

I need to create a vlookup formula that looks at the increase in price which decreases demand, example id price increase between 5% and 10% demand decreases by 8%

Originally Posted by curly88

Is there a formula that counts all the numbers in between 1 and 2, up to two decimal places, but only shows the two numbers - 1 and 2 in the cell??

Yes

I need to create a vlookup formula that looks at the increase in price which decreases demand, example id price increase between 5% and 10% demand decreases by 8%

Did your other lookup question/answer work ok ?