21 Jan 2023

Posted on:

18 Jan 2022

0

# Resolved:Query regarding AND Function

Hi Ned, I would like to better understand the logic behind the AND Function and also how do we know where to place the & symbol in a formula especially referring to the exercise.

Instructor
Posted on:

18 Jan 2022

0

Hi Vishalee,

Good to hear from you.
& and AND are two very different functions.
& is used in the same way as CONCATENATE. It puts together multiple strings of text.
For example if:
cell A1 contains the letter "a"
cell B1 contains the letter "b"
and we have the formula  =A1&B1  in C1, then in C1 we would have "ab" as a result. This simply puts together the text content of the two cells.
Alternatively, we could have simply typed ="a"&"b" without using a dynamic formula that links to cells A1 and B1 and would have obtained the same result - ab.
The AND function, on the other hand, checks whether multiple arguments are true, and if that's the case for all of them without exceptions returns TRUE, otherwise it returns FALSE.

Posted on:

19 Jan 2022

0

Hi Ned,

Thanks a lot. Indeed it answers my question and is very helpful. Much appreciated.

Have a great day! :)

Posted on:

17 Oct 2022

0

Hi Ned,

I was totally stumped on this exercise. I attempted to start my formula by copying & pasting the phrase "Facebook and Google operate in the Internet industry" and worked my way backwards. Unfortunately, I only got as far as setting up the formula  "=&B3 and &B4"

I took a peek at the solution for E3.

=B3 & " and " & B4 & " operate in the " &C3&" industry."

I wanted to know why we needed to add the "&" symbol around B4 and C3, but not B3?
Just to make sure I read correctly, we are putting quotations around phrases or strings of text, correct?

I am a total noob in Excel, so please bare with me. :)