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

[Arno]

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

 

[Roger Govier]

Hi

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

 

[Arno]

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

 

[Arno]

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