Query

[uttamkumar1234]

Hi,

Please help me to know the below mentioned query.

I am able to get TRUE or FALSE when i am using formulae =P2=Q2

But i am not able get result using =P2=Q2=R2.

It is giving me result as "FALSE ONLY".

Please help me how to find out if P=Q=R.

Thanks.

 

[Sinon]

Use this instead:
=IF(AND(P2=Q2,Q2=R2),TRUE)
The reason P2=Q2=R2 doesn't work is that excel analyses this statement like this: P2=Q2=R2 => 2=2=R2 => TRUE =R2 =>TRUE = 2 => FALSE
You can see this yourself if you go to FORMULAS->Evaluate formula

 

[uttamkumar1234]

Hi,

Thanks for the help.Your are very helpful.

Please let me know whether i can hide excel formulae, so that no can view the formulae but its function or result should function as it is.

For example if i use =IF(AND(P2=Q2,Q2=R2),TRUE), the formulae should be hidden but result should be visible and i should be able to use the formulae.

Thanks.

 

[gaz_chops]

You don't need the if statement, try

=AND(P2=Q2,Q2=R2)

 

[uttamkumar1234]

Hi,

I would want o know how to find specific digits from 10 digits numbers?

For example number is 9849555355 and i want to know does this number contains 5's and how many 5's are available? Is there any excel formula or conditional formatting to know it?

 

[uttamkumar1234]

Hi,

I would want o know how to find specific digits from 10 digits numbers?

For example number is 9849555355 and i want to know does this number contains 5's and how many 5's are available? Is there any excel formula or conditional formatting to know it?

.

 

[uttamkumar1234]

Hi,

I would want o know how to find specific digits from 10 digits numbers?

For example number is 9849555355 and i want to know does this number contains 5's and how many 5's are available? Is there any excel formula or conditional formatting to know it?

 

[gaz_chops]

Try

=LEN(A1)-LEN(SUBSTITUTE(A1,5,""))

 

[uttamkumar1234]

Try

=LEN(A1)-LEN(SUBSTITUTE(A1,5,""))

Thank for help

 

[gaz_chops]

You're welcome.