| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display values other than TRUE and FALSE
Try this...
=IF(AND($E2=H$1,$E2<I$1),"Yes","No") -- Biff Microsoft Excel MVP "bmac" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display values other than TRUE and FALSE
Please try this.
=IF(AND($E2=H$1,$E2<I$1),"YES","NO") "bmac" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display values other than TRUE and FALSE
=IF(AND($E2=H$1,$E2<I$1),"YES","NO")
Please try this. "bmac" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display values other than TRUE and FALSE
Perfect, thanks much
"T. Valko" wrote: Try this... =IF(AND($E2=H$1,$E2<I$1),"Yes","No") -- Biff Microsoft Excel MVP "bmac" wrote in message ... 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 . |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display values other than TRUE and FALSE
Thanks very much!
"Alex" wrote: =IF(AND($E2=H$1,$E2<I$1),"YES","NO") Please try this. "bmac" wrote: 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display values other than TRUE and FALSE
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "bmac" wrote in message ... Perfect, thanks much "T. Valko" wrote: Try this... =IF(AND($E2=H$1,$E2<I$1),"Yes","No") -- Biff Microsoft Excel MVP "bmac" wrote in message ... 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 . |
| Reply |
| 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) | |||
Linear Mode
