Determine if whole number exists between a minimum and maximum value

**ocgiraffe** · 02-14-2014, 10:35 AM

This is my first post and I'm hoping someone might be able to point me in the right direction. I have two columns of data with a minimum value in the first column and a maximum value in the second column. What I'm trying to get is an indicator in a third column which tells me if a whole number falls at or between the minimum and maximum values. Here is a sample of my data:

A1 B1 C1
0 0.1 TRUE
0.2 0.5 FALSE
0.6 0.8 FALSE
0.9 1.2 TRUE
1.3 1.6 FALSE
1.7 2.0 TRUE

Thank you in advance!

**Jakobshavn** · 02-14-2014, 10:39 AM

Why is C1 TRUE.............there is no whole number between zero and 0.1

**daddylonglegs** · 02-14-2014, 10:40 AM

In C1 try this formula copied down

=OR(INT(A1)<>INT(B1),CEILING(A1,1)<>CEILING(B1,1))

**XOR LX** · 02-14-2014, 10:44 AM

"...there is no whole number between zero and 0.1"

Considering that zero is defined as an integer, there may be, though that depends on whether the OP's definition of "between" includes or excludes the minimum and maximum.

Regards

**ocgiraffe** · 02-14-2014, 10:49 AM

Thank you very much daddylonglegs your formula produced the result I was expecting! Thanks to all who replied. I should have said integer instead of whole number in my original post.

**Jakobshavn** · 02-14-2014, 10:52 AM

Perhaps:

=ROUNDUP(A1,0)<=B1

**ragulduy** · 02-14-2014, 10:58 AM

@daddylonglegs, assuming it is a valid entry, that method would return false for :
A1=1
B1=1

maybe:
=OR(MOD(A1,1)=0,MOD(B1,1)=0,MOD(B1,1)-MOD(A1,1)<0,B1-A1>=1)