Yes, but you don't need the test for C1=1, because you've alrready dealt
with the C1<1 case.
Hence
=IF(C1<1,0,IF(C1<=10000,10,"Unspecified"))
--
David Biddulph

"Mike H" wrote in message
...

Hopefully I've understtod your question correctly, try this:-

=IF(C1<1,0,IF(AND(C1=1,C1<=10000),10,"Unspecified "))

Mike


"John Nicho" wrote:

Hi,
I'm stuck,
How do I create a Formula for this please:
highlight C5 referencing C1 & if C1 = less than 1 = 0 & if 1 - 10000 =10
Thanks,
John