Excel formula - between two values 1

[OMoore]

Hi all,

This is probably a really simple question....

I have a cell with a value, say value of C1 is 10.

I need a formula to read whether the value in C1 is between 0 and 1000 and if so to return a value of 1, or else return a blank.

I am writing the if statement as follows:

If(0<C1<1000,1,"")

Needless to say it's not working for me!

Any ideas that may help?

Thanks,
Owen

 

[gizmo1973]

=IF(C1<1000,1," ")

Then fill this down if needs be
Should work.

Regards, Phil.
C.E.O. Bodgeit, Leggit & Scarper. International.
"Stuffing things up completely since 1973"

 

[xlbo]

alternatively, if you can have negative values:

=if(and(C1>0,C1<1000),1,"")

Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question

 

[OMoore]

Thanks for the tips.
Geoff - then "and" statement is perfect for what I need.

Thanks.
Owen

 

[gizmo1973]

I tried for ages last night to work that out correctley but Geoff [wry grin] as usual [/wry grin] beat me to it.
Nice one chief

Regards, Phil.
C.E.O. Bodgeit, Leggit & Scarper. International.
"Stuffing things up completely since 1973"

 

[xlbo]

Sorry Gizmo - least you know about ANDs now tho ;-)

Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question