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!
=AND(LEN(B2)<>0)
Gives a true or false, but I thought AND required more than one arg.
Thoughts?
Thank you!
Microsoft ApplicationsMicrosoft Excel
Last Comment
snix123
And, yes, AND is typically used with two or more arguments, each producing a Boolean result.
Kevin
Kevin
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!
Would this work, too, then:
=IF(LEN(B2)<>0,1,0)
or
=IF(LEN(B2)<>0,TRUE,FALSE)
Thank you!
ASKER CERTIFIED SOLUTION
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.
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