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

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

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 6: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 7: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