About
Pricing
Community
Teams
Start Free Trial
Log in
snix123
asked on
7/13/2011
What exactly does this excel formula mean exaclty?
Hello experts, I've seen this used:
=AND(LEN(B2)<>0)
Gives a true or false, but I thought AND required more than one arg.
Thoughts?
Thank you!
Microsoft Applications
Microsoft Excel
5
1
Last Comment
snix123
8/22/2022 - Mon
zorvek (Kevin Jones)
7/13/2011
This:
=AND(LEN(B2)<>0)
is the same as:
=LEN(B2)<>0
And produces FALSE of the length of the value in B2 is 0 or empty, TRUE otherwise.
Kevin
zorvek (Kevin Jones)
7/13/2011
And, yes, AND is typically used with two or more arguments, each producing a Boolean result.
Kevin
snix123
7/13/2011
ASKER
So, there is nothing really wrong with this syntax? Is there an implied IF there?
Would this work, too, then:
=IF(LEN(B2)<>0,1,0)
or
=IF(LEN(B2)<>0,TRUE,FALSE)
Thank you!
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ASKER CERTIFIED SOLUTION
zorvek (Kevin Jones)
7/13/2011
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
snix123
7/18/2011
ASKER
Thank you.
=AND(LEN(B2)<>0)
is the same as:
=LEN(B2)<>0
And produces FALSE of the length of the value in B2 is 0 or empty, TRUE otherwise.
Kevin