If/And formula showing true/false instead of cell value
 

Hello,

I have entered the following formula in a worksheet =AND(A3=L2,A5=Q2,L2,"")

The result I get is True or False but I would need to see the actual value
of L2 which is a number, like 4501615652

How is it possible to ament the formula in order to get only the number
rather than true or false?

Thank you ! Arno

If/And formula showing true/false instead of cell value
 

Hi

Try
=IF(AND(A3=L2,A5=Q2),L2,"")


--
Regards
Roger Govier

"Arno" wrote in message
...
Hello,

I have entered the following formula in a worksheet
=AND(A3=L2,A5=Q2,L2,"")

The result I get is True or False but I would need to see the actual value
of L2 which is a number, like 4501615652

How is it possible to ament the formula in order to get only the number
rather than true or false?

Thank you ! Arno

If/And formula showing true/false instead of cell value
 

Thank you Roger - That was quick and effective ! Thank you again - Have a
good day ! Arno

Roger, but you people giving support to other, you just do it as a hobby or
you are employed ? I am curios :)

"Roger Govier" wrote:

Hi

Try
=IF(AND(A3=L2,A5=Q2),L2,"")


--
Regards
Roger Govier

"Arno" wrote in message
...
Hello,

I have entered the following formula in a worksheet
=AND(A3=L2,A5=Q2,L2,"")

The result I get is True or False but I would need to see the actual value
of L2 which is a number, like 4501615652

How is it possible to ament the formula in order to get only the number
rather than true or false?

Thank you ! Arno

If/And formula showing true/false instead of cell value
 

Roger,

Thank you for your explaination. ...now I appreciate even more this forum
because it is a rare example of people, like you, helping others without
being paid.

Besides, the info you provide, so quickly, would take ages to find and
normal people like me would never progress with these applications.

Thank you and all the best ! I really hope that one day soon microsoft will
reward you all for the great help you give :)

"Roger Govier" wrote:

Hi Arno

These Newsgroups are answered by members of the community, not Microsoft
employees.
Nobody receives any remuneration for giving support.
Some of us have been recognised by Microsoft as Most Valued Professionals
(MVP), but we are not employees of Microsoft, nor do we receive payment.
So I guess the answer to your question is - it is a hobby.
--
Regards
Roger Govier

"Arno" wrote in message
...
Thank you Roger - That was quick and effective ! Thank you again - Have a
good day ! Arno

Roger, but you people giving support to other, you just do it as a hobby
or
you are employed ? I am curios :)

"Roger Govier" wrote:

Hi

Try
=IF(AND(A3=L2,A5=Q2),L2,"")


--
Regards
Roger Govier

"Arno" wrote in message
...
Hello,

I have entered the following formula in a worksheet
=AND(A3=L2,A5=Q2,L2,"")

The result I get is True or False but I would need to see the actual
value
of L2 which is a number, like 4501615652

How is it possible to ament the formula in order to get only the number
rather than true or false?

Thank you ! Arno