|Are you sure that you posted the formula that you used in your spreadsheet?|
Using the formula you posted (copied directly from your post) I do not get FALSE for any number, nor would I expect to.
An IF statement is evaluated from left to right, and stopping when a TRUE is returned.
Let's break down the formula that you posted:
IF(A1<=7,B2,... TRUE for any value less than or equal to 7.
IF(A1<>8-14,C2... TRUE for any value not equal to 8 minus 14 (-6)
IF(A1>=15,D2... TRUE for any value greater than or equal to 15, but it will never make it that far based on the inputs you are using.
When A1 contains any number from 7 and below, the first condition will be TRUE and the value in B2 will be returned.
When A1 contains any number above 7, it won't be equal to -6 and the value from C2 will be returned.
If you are getting FALSE with values from 15 - 19 in A1, you must be using something different than what you posted.
All that said, this is the formula that should work for you, remembering that the evaluation will stop as soon as a condition is TRUE:
Note: This formula will return the value in B2 for any number from 7 down to negative infinity and the value in D2 for any number from 15 up to positive infinity.
Since you say you will only be entering 1 - 19, that shouldn't be a problem. If you need to return something different if the value in A1 is something other than 1 - 19, let us know.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.