what does "" mean in an excel formula

C

Conan Kelly

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
 
N

nutcracker

Thanks.

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

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

Bob I

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.
 
C

Conan Kelly

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Returning "False" 1
what do these ----> {0.6,2,4,5,6,7,9} and {0,21,111,201,551,1101,2701}means in an excel formula? 1
What does -- symbol mean in an excel formulae eg: SUMPRODUCT(--(A1:A10="Luke 2
What is "--" in Excel Formula (SUMPRODUCT) 2
what does "^" symbol mean in excel 2
what does mean excel? 1
Cannot access to Office Insider 0
What does "" mean in an equation 1

Top