what does "" mean in an excel formula
 

what does "" mean in an excel formula e.g. =if(c43="","", +sum

what does "" mean in an excel formula
 

"" is an Empty String

nutcracker wrote:

what does "" mean in an excel formula e.g. =if(c43="","", +sum

what does "" mean in an excel formula
 

nutcracker,

what this formula says is "If cell c43 is blank (or appears blank), then
this cell should appear blank, else return +sum...)

HTH,

Conan



"nutcracker" wrote in message
...
what does "" mean in an excel formula e.g. =if(c43="","", +sum

what does "" mean in an excel formula
 

Thanks.

So in the example used if(c43="","", +sum ...

what does "","" mean - double blank?


"Conan Kelly" wrote:

nutcracker,

what this formula says is "If cell c43 is blank (or appears blank), then
this cell should appear blank, else return +sum...)

HTH,

Conan



"nutcracker" wrote in message
...
what does "" mean in an excel formula e.g. =if(c43="","", +sum

what does "" mean in an excel formula
 

No, IF Cell C43 is Blank, Then make this cell Blank. The first comma is
the "then", the second comma is the else part of the If statement.

nutcracker wrote:

Thanks.

So in the example used if(c43="","", +sum ...

what does "","" mean - double blank?


"Conan Kelly" wrote:


nutcracker,

what this formula says is "If cell c43 is blank (or appears blank), then
this cell should appear blank, else return +sum...)

HTH,

Conan



"nutcracker" wrote in message
...

what does "" mean in an excel formula e.g. =if(c43="","", +sum

what does "" mean in an excel formula
 

nutcracker,

It is just like I said.

The IF() function has 3 arguments: the logical test, the result if true, and the result if false (in that order.......separated by commas).

=IF(Logical Test, Result if True, Result if False)

So, using your example:
Logical Test = [c43=""]
Result if True = [""]
Result if False = [+sum...]

=if(c43="","", +sum...)

the commas just separate the 3 different arguments.

so your equation is saying "If cell c43 is blank (or appears blank), then this cell should appear blank, else this cell should display the results of +sum..."


HTH,

Conan







"nutcracker" wrote in message ...
Thanks.

So in the example used if(c43="","", +sum ...

what does "","" mean - double blank?


"Conan Kelly" wrote:

nutcracker,

what this formula says is "If cell c43 is blank (or appears blank), then
this cell should appear blank, else return +sum...)

HTH,

Conan



"nutcracker" wrote in message
...
what does "" mean in an excel formula e.g. =if(c43="","", +sum