| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display values other than TRUE and FALSE
Hello, I have the following formula that returns TRUE and FALSE values.
=AND($E2=H$1,$E2<I$1) How do I modify the formula to display "YES" and "NO" instead of true and false. Thanks very much in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I format cells containing a value to display as true/false | Excel Discussion (Misc queries) | |||
| Display TRUE / FALSE Instead Of 1 / 0 | 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 Discussion (Misc queries) | |||
| match data in 2 sheets then display true/false from vlkup | Excel Worksheet Functions | |||
| Simple Check Box - without True/False values | Excel Discussion (Misc queries) | |||
Threaded Mode
