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