=LOOKUP(C1,{-10000,1,10001},{0,10,"OverRange"})

Vaya con Dios,
Chuck, CABGx3



"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