Using Quotes in Formulas
 

Hello everyone,

Basic question:
Is there a set quideline on when to use quotes in formulas and array
formulas?
--
Thank you... Elaine

Hi!

Can you be more specific?

You must use quotes when referencing text values:

=IF(A1="Red","yes it is","no it isn't")

=SUMIF(A1:A10,"Ten",B1:B10)

Do not use quotes when referencing numbers:

=IF(A1=10,10,0)

=SUMIF(A1:A10,10,B1:B10)

Biff

"Elaine" wrote in message
...
Hello everyone,

Basic question:
Is there a set quideline on when to use quotes in formulas and array
formulas?
--
Thank you... Elaine

What about in Array formulas? Does the same rule/guide apply?
--
Thank you... Elaine


"Biff" wrote:

Hi!

Can you be more specific?

You must use quotes when referencing text values:

=IF(A1="Red","yes it is","no it isn't")

=SUMIF(A1:A10,"Ten",B1:B10)

Do not use quotes when referencing numbers:

=IF(A1=10,10,0)

=SUMIF(A1:A10,10,B1:B10)

Biff

"Elaine" wrote in message
...
Hello everyone,

Basic question:
Is there a set quideline on when to use quotes in formulas and array
formulas?
--
Thank you... Elaine

I would use the help function on when to use Quotes for specific functions.
for example you often, but not always need to use quotes in countif() or
sumif() equations, Many eqations which format things [text()] require quotes.

Generally you use quotes with text, logic or formats, and do not use them
with numbers. but as said above, not always.


"Elaine" wrote:

Hello everyone,

Basic question:
Is there a set quideline on when to use quotes in formulas and array
formulas?
--
Thank you... Elaine

Just a simple thank you for your quick response to my basic question.
--
Elaine


"Biff" wrote:

Hi!

Can you be more specific?

You must use quotes when referencing text values:

=IF(A1="Red","yes it is","no it isn't")

=SUMIF(A1:A10,"Ten",B1:B10)

Do not use quotes when referencing numbers:

=IF(A1=10,10,0)

=SUMIF(A1:A10,10,B1:B10)

Biff

"Elaine" wrote in message
...
Hello everyone,

Basic question:
Is there a set quideline on when to use quotes in formulas and array
formulas?
--
Thank you... Elaine

Thank you this answers my question.
--
Elaine


"bj" wrote:

I would use the help function on when to use Quotes for specific functions.
for example you often, but not always need to use quotes in countif() or
sumif() equations, Many eqations which format things [text()] require quotes.

Generally you use quotes with text, logic or formats, and do not use them
with numbers. but as said above, not always.


"Elaine" wrote:

Hello everyone,

Basic question:
Is there a set quideline on when to use quotes in formulas and array
formulas?
--
Thank you... Elaine