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

=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

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

Hi There,

I believe that the formula should be =IF(C1<1,0,IF(AND(C11,C1<10000),10))

Here's an explanation of the IF and AND formulas in Microsoft Excel for
reference purposes.

IF(Logical_test,Value_if_true,Value_if_false)
Logical_test - expression that can be evaluated as True or False (e.g. C1
5, C2 <3)
Value_if_true - the value that will be returned if the expression in the
Logical_test is True.
Value_if_false - the value that will be returned if the expression in the
Logical_test is false.

AND(Logical1, Logical2,...Logicaln);

Logicaln - the value that will be tested if it is either true or false
--
Chester C. Coronel
Junior BSIT Student
University of Asia and the Pacific, Philippines
Read the StudentEmpowered Blog!http://msforums.ph/blogs/chestercoronel


"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

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

Another way assuming 0 on either side of your interval range.

=10*(C1=1)*(C1<=10000)

--
HTH :)
Dana DeLouis
Windows XP & Office 2007


"John Nicho" <John wrote in message
...
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