G
Guest
How do I make the result of a true/false formula display as TRUE or FALSE
instead of 1 or 0?
instead of 1 or 0?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
T. Valko
What's your formula look like?
Biff
Biff
G
Guest
it depends on which logical formaula but here's one way.
=IF(AND(1<A2, A2<100), 1, 0)
=IF(AND(1<A2, A2<100), 1, 0)
D
Domenic
ExcelUser123 said: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?
G
Guest
hi exceluser
for an IF formula
maybe like this
=if(1=1,1,0) then replace it with
=if(1=1,TRUE,FALSE)
regards
for an IF formula
maybe like this
=if(1=1,1,0) then replace it with
=if(1=1,TRUE,FALSE)
regards
G
Guest
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
=IF(B5=1,"TRUE",IF(B5=0,"FALSE","NULL"))
Hope it helps
Hank
D
David Biddulph
Remember that if you put "TRUE" and "FALSE" in quotes, they will be text
strings, not logical values.
strings, not logical values.
M
Marc
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...
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...
G
Guest
The formula is =D54>0 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?
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?
D
Dave Peterson
Toggle this setting:
Tools|Options|Transition tab
Uncheck "Transition formula evaluation"
You may find it better to uncheck all those lotus 123 settings.
Tools|Options|Transition tab
Uncheck "Transition formula evaluation"
You may find it better to uncheck all those lotus 123 settings.
M
Marc
That's a completely different question.........
ExcelUser123 said:The formula is =D54>0 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?
G
Guest
Thank you Dave. Updating that setting solved the problem.