If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel and double quotes in functions

Gerry1995 · 2013-10-17 18:44:46

This is a question just to satisfy my curiosity, if I am using a function in excel and text is the output, why do I have to use double quotes instead of single quotes. e.g IF((A2>D2),"A is bigger","A is not bigger")

17-10-2013 07:44PM

#1

Gerry1995

Registered Users, Registered Users 2 Posts: 224 ✭✭

Join Date: June 2007

Posts: 132

This is a question just to satisfy my curiosity, if I am using a function in excel and text is the output, why do I have to use double quotes instead of single quotes.
e.g IF((A2>D2),"A is bigger","A is not bigger")

0

Comments

#2 17-10-2013 08:17PM

FSL

Registered Users, Registered Users 2 Posts: 1,456 ✭✭✭

Join Date: February 2006

Posts: 1419

Because " is the delimiter for a string. A ' is used to precede a string in a cell which otherwise would be considered a formula

0