Using Quotes in Formulas

E

Elaine

Hello everyone,

Basic question:
Is there a set quideline on when to use quotes in formulas and array
formulas?
 
B

Biff

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
 
B

bj

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.
 
E

Elaine

Thank you this answers my question.
--
Elaine


bj said:
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 said:
Hello everyone,

Basic question:
Is there a set quideline on when to use quotes in formulas and array
formulas?
 
Top