• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

if(or....?

Duffer

New Member
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 .
 
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,
 
=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
 
=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 .
 
Back
Top