What does " mean in excel
in [Functions]
|
Prev: In a formula, how do I set a maximum acceptable value?
Next: How do I tell Excel to insert data from a cell 4 to the left?
From: Jane on 5 Mar 2010 23:34 When working in excel and doing my labs, I am often told to use " " in my formulas but I don't know what " " stand for and the ! is also used, can someone explain to me what " " and ! mean?
From: trip_to_tokyo on 6 Mar 2010 00:09 EXCEL 2007 " " 1. This can mean that text is being inserted in the formula. 2. In this example:- =IF(AND(C2="East",D2<20),D2*100%,"Not Applicable") The 2 words in inverted commas are text. "East" means if the formula finds that text (East) in cell C2. "Not Applicable" means that Not Applicable will be placed into a cell if the 2 conditions in the formula are found to be false. If my comments have helped please hit Yes. "Jane" wrote: > When working in excel and doing my labs, I am often told to use " " in my > formulas but I don't know what " " stand for and the ! is also used, can > someone explain to me what " " and ! mean?
From: trip_to_tokyo on 6 Mar 2010 00:15 EXCEL 2007 ! Here is an example of use of the above. 1. In Sheet1 cell A1 I have the following text:- sheet1 cell a1 2. In Sheet2 cell A1 I have the followingformula:- =Sheet1!A1 This returns:- sheet1 cell a1 - in Sheet2 cell A1. The above is one example of how ! is used. Please hit Yes if my comments have helped. Thanks. "Jane" wrote: > When working in excel and doing my labs, I am often told to use " " in my > formulas but I don't know what " " stand for and the ! is also used, can > someone explain to me what " " and ! mean?
From: Chip Pearson on 6 Mar 2010 13:50 It is the multiplication operator. E.g., =A1*B1 multiplies cell A1 by cell B1. Cordially, Chip Pearson Microsoft Most Valuable Professional, Excel, 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com On Fri, 5 Mar 2010 20:34:49 -0800, Jane <Jane(a)discussions.microsoft.com> wrote: >When working in excel and doing my labs, I am often told to use " " in my >formulas but I don't know what " " stand for and the ! is also used, can >someone explain to me what " " and ! mean?
From: Gord Dibben on 6 Mar 2010 16:50
Do not use " " in your formulas. That creates a space. Use "" to return nothing as a condition.. e.g. =IF(A1="","",A1) Means if A1 is empty, show nothing.....if something in A1 show that. =IF(A1=" ", " ",A1) is entirely different Means if A1 contains a space, return a space. Not good. Gord Dibben MS Excel MVP On Fri, 5 Mar 2010 20:34:49 -0800, Jane <Jane(a)discussions.microsoft.com> wrote: >When working in excel and doing my labs, I am often told to use " " in my >formulas but I don't know what " " stand for and the ! is also used, can >someone explain to me what " " and ! mean? |