SOLVED

Quotations in conditional formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-1501824%22%20slang%3D%22en-US%22%3EQuotations%20in%20conditional%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1501824%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%20-%20I%20have%20a%20question%20on%20when%20to%20use%20quotations%20in%20conditional%20formulas.%20For%20example%2C%20in%20COUNTIFS%20function%2C%20for%20condition%20%22%26lt%3B%3D%22%2C%20the%20formula%20should%20be%20%3D%20COUNTIFS(XXXX%2C%22%26lt%3B%3D%22%26amp%3BA1).%20The%20quotations%20have%20to%20be%20included.%20However%2C%20in%20IF%20function%2C%20it%20should%20be%20%3D%20IF(XXXX%26lt%3B%3DXXXX).%20My%20question%20is%20why%20quotations%20are%20not%20included%20here.%20When%20should%20the%20quotations%20be%20used%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1501824%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1502093%22%20slang%3D%22en-US%22%3ERe%3A%20Quotations%20in%20conditional%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1502093%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F698551%22%20target%3D%22_blank%22%3E%40liang17%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20this%20from%20Excel%20Help%20will%20help.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mathetes_0-1593627737135.png%22%20style%3D%22width%3A%20555px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F202698iBD103224F815DED9%2Fimage-dimensions%2F555x313%3Fv%3D1.0%22%20width%3D%22555%22%20height%3D%22313%22%20title%3D%22mathetes_0-1593627737135.png%22%20alt%3D%22mathetes_0-1593627737135.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi everyone - I have a question on when to use quotations in conditional formulas. For example, in COUNTIFS function, for condition "<=", the formula should be = COUNTIFS(XXXX,"<="&A1). The quotations have to be included. However, in IF function, it should be = IF(XXXX<=XXXX). My question is why quotations are not included here. When should the quotations be used? 

2 Replies
Highlighted
Solution

@liang17 

 

Maybe this from Excel Help will help.

mathetes_0-1593627737135.png

It's a bit ambiguous, to be sure. The fact that either 32 or "32" is acceptable is confusing. It appears that the >= by itself is not in quotes, it would be the entire expression, ">=32"

Highlighted
Thanks, @mathetes for the reply. This is what I am thinking. <= by itself in COUNTIF formula seems an expression so Excel doesn't recognize it. However, it is okay to not have quotes in IF formulas. It's a bit confusing sometimes. I was searching for the answer - it seems that when to use quotes with conditional statements is unclear. People need to try one and another.