| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
| What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Programming | |||
| True and false formula | Excel Worksheet Functions | |||
| IF function...cell ref is a formula so True is retd when False sh | Excel Worksheet Functions | |||
| Logical Format showing 0/1 and not True/False. | Excel Discussion (Misc queries) | |||
Hybrid Mode
