Avatar of snix123
snix123
 asked on

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 ApplicationsMicrosoft Excel

Avatar of undefined
Last Comment
snix123

8/22/2022 - Mon
zorvek (Kevin Jones)

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)

And, yes, AND is typically used with two or more arguments, each producing a Boolean result.

Kevin
snix123

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)

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

ASKER
Thank you.