Testing two conditions, one over rides the other?

The following code is attempting to check the conditon of the value of a cell.
If the value is less than ".108" I want to show the difference.
If the value is greater than ".110" I want to show the difference.

I think my problem right now is, if condition one is met condition two over rides condition one. (or vice~versa).

How can I make this work?

Please Login or Register  to view this content.

You know, I used nearly (I had the long version) the same code as you including missing the second "end if" at the end of the code, butt, and I use that word literally, what I did not see was the typo I made with the numeric value I wanted to use!

I typed ".108" instead of ".109"!
Since my less than 5th grade math is less than par, and I beat them damn kids on that show already, I may need to go back to skool!

So, a value of say; ".1089" would not be less than ".108" hence a blank cell. At this point I know I'm on track as I just asked my kid. :lol:

Thanks for your help! (Seriously)