View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arno Arno is offline
external usenet poster
 
Posts: 60
Default 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