0 < F6 < 12

T

TomHinkle

are you a C programmer??

I don't think that will work.. have to use AND function

AND(0<F6,F6<12)
 
T

TomHinkle

C was the precursor to C++, C#... You were able to do a LOT of stuff in it
like you are asking.
ex.. F6++ would add one to F6.

in VBA there is a BETWEEN operator as well (.. F6 between 0 AND 12 ), BUT
sounded like you were sticking to a simple formula..
 
B

Bob Phillips

You obviously aren't <vbg>

It is someone who programs using C, C++ languages, quite low-level
languages.
 
M

Michelle P

And I think I'm on my seventh nest, so this IF formula is about to come to an
end. And I'm only halfway done. Grr.
 
D

Dana DeLouis

Hi Michelle. Just for gee-wiz. In another program, the internal form of
a<b<c<d is the following...
Less[a,b,c,d]

Don't know if this would help, but here is a Poor-man's version of that
functionality...

Function Less(ParamArray v()) As Boolean
Dim p As Long
If UBound(v) = 0 Then Exit Function
Less = v(0) < v(1)
For p = 2 To UBound(v)
Less = Less And (v(p - 1) < v(p))
If Not Less Then Exit Function
Next p
End Function

On a worksheet, the following should work:
=Less(0,F6,12)

This returns True
=Less(2,4,6,8,10)

This returns False
=Less(2,4,6,8,7)

HTH :>)
 
Top