Here is a simple problem I'm sure that I need solving...
I want to be able to pick a number shown in a cell within a range of numbers, for example in Cell A1 I will input a number (4.25 for example). In cell A2 I need a formula to look at the number in A1 and if the figure if between 0 & 10 it will show the information in Cell B1. If the figure is between 10.01 & 50 it will show the information in B2 and so on. The number in Cell A1 will sometimes be a whole number or fractions of 0.25, not sure if that makes any difference?
Thank
Jon
Bookmarks