Formula How

J

John Nicho

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
 
M

Mike H

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

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

Mike
 
C

ChesterCoronel

Hi There,

I believe that the formula should be =IF(C1<1,0,IF(AND(C1>1,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
 
D

David Biddulph

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"))
 
D

Dana DeLouis

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

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