Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Formulas for counting multiple conditions | Excel Worksheet Functions | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
Problem with named formula's | Excel Worksheet Functions | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |