Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display TRUE / FALSE Instead Of 1 / 0
How do I make the result of a true/false formula display as TRUE or FALSE
instead of 1 or 0? |
#2
|
|||
|
|||
Answer: Display TRUE / FALSE Instead Of 1 / 0
To display TRUE or FALSE instead of 1 or 0 in Excel:
Note that you can customize the text that's displayed by changing the words "TRUE" and "FALSE" in the formula to whatever you like. For example, you could use "Yes" and "No" instead.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display TRUE / FALSE Instead Of 1 / 0
What's your formula look like?
Biff "ExcelUser123" wrote in message ... How do I make the result of a true/false formula display as TRUE or FALSE instead of 1 or 0? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display TRUE / FALSE Instead Of 1 / 0
it depends on which logical formaula but here's one way.
=IF(AND(1<A2, A2<100), 1, 0) "ExcelUser123" wrote: How do I make the result of a true/false formula display as TRUE or FALSE instead of 1 or 0? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display TRUE / FALSE Instead Of 1 / 0
In article ,
ExcelUser123 wrote: How do I make the result of a true/false formula display as TRUE or FALSE instead of 1 or 0? Can you post the formula? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display TRUE / FALSE Instead Of 1 / 0
hi exceluser
for an IF formula maybe like this =if(1=1,1,0) then replace it with =if(1=1,TRUE,FALSE) regards -- ***** birds of the same feather flock together.. "ExcelUser123" wrote: How do I make the result of a true/false formula display as TRUE or FALSE instead of 1 or 0? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display TRUE / FALSE Instead Of 1 / 0
Here is another way if your cell is either 1 or 0,
=IF(B5=1,"TRUE",IF(B5=0,"FALSE","NULL")) Hope it helps Hank "ExcelUser123" wrote: How do I make the result of a true/false formula display as TRUE or FALSE instead of 1 or 0? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display TRUE / FALSE Instead Of 1 / 0
Remember that if you put "TRUE" and "FALSE" in quotes, they will be text
strings, not logical values. -- David Biddulph "Hank" wrote in message ... Here is another way if your cell is either 1 or 0, =IF(B5=1,"TRUE",IF(B5=0,"FALSE","NULL")) "ExcelUser123" wrote: How do I make the result of a true/false formula display as TRUE or FALSE instead of 1 or 0? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display TRUE / FALSE Instead Of 1 / 0
As long as the formula truly results in a logical 1 or 0, then you can
create a custom format like: "TRUE";;"FALSE"; positive #;negative #;zero;text So for any non-zero number (which if the formula is truly a logical could only be 1) the format will be "TRUE", nothing visible if it's negative, "FALSE" if 0, and nothing if text... "ExcelUser123" wrote in message ... How do I make the result of a true/false formula display as TRUE or FALSE instead of 1 or 0? |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display TRUE / FALSE Instead Of 1 / 0
The formula is =D540 where D54 is a the NPV of an investment being evaluated
in a finance model across multiple years. I understand how to write the IF statement to generate the text values of "TRUE" or "FALSE". I am trying to determine why this formula on my Desktop computer results in a display of TRUE or FALSE (logical values not text) and on my Laptop computer it results in a display of 1 or 0. Both machines are running identical installations of Office 2003 in XP. I looked at display options, formatting, styles, etc. but cannot find anything that explains the difference. Anyone have any ideas or similar experience? "Domenic" wrote: In article , ExcelUser123 wrote: How do I make the result of a true/false formula display as TRUE or FALSE instead of 1 or 0? Can you post the formula? |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display TRUE / FALSE Instead Of 1 / 0
Toggle this setting:
Tools|Options|Transition tab Uncheck "Transition formula evaluation" You may find it better to uncheck all those lotus 123 settings. ExcelUser123 wrote: How do I make the result of a true/false formula display as TRUE or FALSE instead of 1 or 0? -- Dave Peterson |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display TRUE / FALSE Instead Of 1 / 0
That's a completely different question.........
"ExcelUser123" wrote in message ... The formula is =D540 where D54 is a the NPV of an investment being evaluated in a finance model across multiple years. I understand how to write the IF statement to generate the text values of "TRUE" or "FALSE". I am trying to determine why this formula on my Desktop computer results in a display of TRUE or FALSE (logical values not text) and on my Laptop computer it results in a display of 1 or 0. Both machines are running identical installations of Office 2003 in XP. I looked at display options, formatting, styles, etc. but cannot find anything that explains the difference. Anyone have any ideas or similar experience? "Domenic" wrote: In article , ExcelUser123 wrote: How do I make the result of a true/false formula display as TRUE or FALSE instead of 1 or 0? Can you post the formula? |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display TRUE / FALSE Instead Of 1 / 0
Thank you Dave. Updating that setting solved the problem.
"Dave Peterson" wrote: Toggle this setting: Tools|Options|Transition tab Uncheck "Transition formula evaluation" You may find it better to uncheck all those lotus 123 settings. ExcelUser123 wrote: How do I make the result of a true/false formula display as TRUE or FALSE instead of 1 or 0? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Question (Organizing Data) | Excel Discussion (Misc queries) | |||
Repeatable Fixed Width Import | Excel Discussion (Misc queries) | |||
Disable CUT via toolbars or shortcut keys | Excel Discussion (Misc queries) | |||
Help in VBA code! | Excel Discussion (Misc queries) | |||
Grand Totals @ Same Place | Excel Worksheet Functions |