LinkBack URL
About LinkBacks
When making a logical test in a cell the result is shown as the full 4-5 letter words 'TRUE' and 'FALSE' and that takes up a lot of unnecessary space.
Is it possible make the logical tests show results as '1' and '0'?
NSV
When making a logical test in a cell the result is shown as the full 4-5 letter words 'TRUE' and 'FALSE' and that takes up a lot of unnecessary space.
Is it possible make the logical tests show results as '1' and '0'?
NSV
Try something like
=--(condition)
such as
=--(OR(A1="xyz",B1<>"blue"))
yes add 0 to result or use --
=--(a1=10)
=(a1=10)+0
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
use the double-hypen --
for example: =--(B2>E2)
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
... or multiply a condition with 1
=(condition)*1 will result in 1 if "condition" returns TRUE, and 0 if FALSE.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
Thank you - I did not realize that the TRUE/FALSE result could be treated like a number.
NSV
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks