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.
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.
Does this answer your question, please?
Hi Ned,
Thanks a lot. Indeed it answers my question and is very helpful. Much appreciated.
Have a great day! :)
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. :)
Thanks in advance!
Hello all, I discovered in this spacing do matter, there is no initial string to attach or bind to so we don't need &(ampersand) in front of first but for the rest we do. Please correct me if i'm wrong. I'm an amateur here. Osm! :)-