Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Functional difference b/n "" & " "
I've noticed in various postings that the quotes symbols are used (or
suggested to be used) without a space between them. What is the difference between including or not including the space? An example of it's use would be: IF (A1=B1,+C1,"") Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Functional difference b/n "" & " "
Using "" enters nothing, ie a blank cell. Using " " enters a space.
-- Ian -- "Julie Quass" wrote in message ... I've noticed in various postings that the quotes symbols are used (or suggested to be used) without a space between them. What is the difference between including or not including the space? An example of it's use would be: IF (A1=B1,+C1,"") Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Functional difference b/n "" & " "
With your sample formula, there would be no visible difference......both
cases would appear empty, but by using the " " there would actually be a space character in the cell. Vaya con Dios, Chuck, CABGx3 "Julie Quass" wrote: I've noticed in various postings that the quotes symbols are used (or suggested to be used) without a space between them. What is the difference between including or not including the space? An example of it's use would be: IF (A1=B1,+C1,"") Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Functional difference b/n "" & " "
I think it's a pet peeve of many developers that people write formulas like:
=if(a1=b1,c1," ") or use the space bar to clear the contents of cells (instead of hitting the delete key). It can really screw up formulas that look like: =if(a1="","one thing","another") It would have to be rewritten as: =if(trim(a1)="","one thing","another") just to make sure. ==== ps. That leading + (in +c1) is another pet peeve <vbg. It isn't necessary. Julie Quass wrote: I've noticed in various postings that the quotes symbols are used (or suggested to be used) without a space between them. What is the difference between including or not including the space? An example of it's use would be: IF (A1=B1,+C1,"") Thanks! -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Functional difference b/n "" & " "
Thanks everyone! Obviously I'm a bit of a "detail" nut! Happy Holidays!
"Dave Peterson" wrote: I think it's a pet peeve of many developers that people write formulas like: =if(a1=b1,c1," ") or use the space bar to clear the contents of cells (instead of hitting the delete key). It can really screw up formulas that look like: =if(a1="","one thing","another") It would have to be rewritten as: =if(trim(a1)="","one thing","another") just to make sure. ==== ps. That leading + (in +c1) is another pet peeve <vbg. It isn't necessary. Julie Quass wrote: I've noticed in various postings that the quotes symbols are used (or suggested to be used) without a space between them. What is the difference between including or not including the space? An example of it's use would be: IF (A1=B1,+C1,"") Thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to find the working days difference between to dates? | Excel Discussion (Misc queries) | |||
Percentage difference calc that knows the largest figure | Excel Discussion (Misc queries) | |||
Calculating Time difference based on a condition | Excel Discussion (Misc queries) | |||
charting a difference of 2 columns' w/o adding a difference column | Charts and Charting in Excel | |||
How to get difference in hours | Excel Worksheet Functions |