if(or....?

[Duffer]

Hi ,

Can anyone tell why this does not work the 1st part ok 2nd part not ok .

=if(or(c10<0,c10>5),-1,2)

Cheers ,
Duffer .

 

[Somendra Misra]

Hi Duffer,

Why you said it's not working, it giving result as per the logic given by you.

May be you should explain the logic.

Regards,

 

[Hui]

=if(or(c10<0,c10>5),-1,2)
says:
Return -1 if the value in C10 is less than 0 or greater than 5
or
Return 2 if the value in C10 is Greater than or equal to 0 or less than or equal to 5

 

[Duffer]

=if(or(c10<0,c10>5),-1,2)
says:
Return -1 is the value in C10 is less than 0 or greater than 5
or
Return 2 if the value in C10 is Greater than or equal to 0 or less than or equal to 5

Thanks for replying Somendra and Hui ,
i thought what would happen would be that if the return is less than zero would be -1 and the return larger than 5 would be 2 , i will try another way ,

Regards , Duffer .

 

[Hui]

Duffer,
Try: =If(C10<0,-1,If(C10>5,2, xx))
where xx is a value if C10 is between 0 and 5

 

[Duffer]

Duffer,
Try: =If(C10<0,-1,If(C10>5,2, xx))
where xx is a value if C10 is between 0 and 5

Thanks Hui ,

Exactly what i wanted .

Regards ,
Duffer .