| 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 |
| 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) | |||
Threaded Mode
