Excel IF Question

[say4nything]

Hello

I'm having trouble with a bit of a tricky IF function on microsoft excel.

I'll attempt to put this into words..

Basically, I have Column A set to multiples of 1.6. So, starting at 0, 1.6, 3.2, 4.8, etc. all the way to several hundred
(years)

In Column B I have multiples of 0.308. So, 0, 0.308, 0.616, etc...

In Column C I have the same multiples of Column B + 8.5446*10^-4, so...0.30885446, 0.61685446, etc... all up to a few hundred (years)

So, what I want to find if any of the values in Column A falls between the Column C-D numbers

Any ideas?

 

[say4nything]

@bschwartz - yeah idk... it's not working for me. I guess I'll have to fiddle with it

 

[say4nything]

Correction. Try this formula in D2 and fill down:

=--(A2>$B$2:$B$301)*--(A2<$C$2:$C$301)

When I entered this, it just gave me zeros...is it missing something?

 

[bschwartz]

Yes, I decided to use 0s and 1s so that you could more easily count all of the numbers that match your criteria, by summing the column of 1s and 0s.

Did you want something else displayed?