0 < F6 < 12
 

Can I use this in an IF formula? rather than F60,F6<12.

Thanks,
Michelle

are you a C programmer??

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

AND(0<F6,F6<12)



"Michelle P" wrote:

Can I use this in an IF formula? rather than F60,F6<12.

Thanks,
Michelle

OK, thanks.

What's a C programmer?

"TomHinkle" wrote:

are you a C programmer??

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

AND(0<F6,F6<12)



"Michelle P" wrote:

Can I use this in an IF formula? rather than F60,F6<12.

Thanks,
Michelle

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..

"Michelle P" wrote:

OK, thanks.

What's a C programmer?

"TomHinkle" wrote:

are you a C programmer??

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

AND(0<F6,F6<12)



"Michelle P" wrote:

Can I use this in an IF formula? rather than F60,F6<12.

Thanks,
Michelle

You obviously aren't <vbg

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

--
HTH

Bob Phillips

"Michelle P" wrote in message
...
OK, thanks.

What's a C programmer?

"TomHinkle" wrote:

are you a C programmer??

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

AND(0<F6,F6<12)



"Michelle P" wrote:

Can I use this in an IF formula? rather than F60,F6<12.

Thanks,
Michelle

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.

"TomHinkle" wrote:

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..

"Michelle P" wrote:

OK, thanks.

What's a C programmer?

"TomHinkle" wrote:

are you a C programmer??

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

AND(0<F6,F6<12)



"Michelle P" wrote:

Can I use this in an IF formula? rather than F60,F6<12.

Thanks,
Michelle

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 :)
--
Dana DeLouis
Win XP & Office 2003


"Michelle P" wrote in message
...
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.

"TomHinkle" wrote:

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..

"Michelle P" wrote:

OK, thanks.

What's a C programmer?

"TomHinkle" wrote:

are you a C programmer??

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

AND(0<F6,F6<12)



"Michelle P" wrote:

Can I use this in an IF formula? rather than F60,F6<12.

Thanks,
Michelle

Thanks for the help everyone.

"Michelle P" wrote:

Can I use this in an IF formula? rather than F60,F6<12.

Thanks,
Michelle