what does "" mean in an excel formula

  • Thread starter Thread starter nutcracker
  • Start date Start date
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
 
Thanks.

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

what does "","" mean - double blank?
 
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,

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

What does { } mean in excel formulas? 4
What does "" mean in Excel? 2
formula problem 4
What does -- symbol mean in an excel formulae eg: SUMPRODUCT(--(A1:A10="Luke 3
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 excel 2
Spell check strings 2
What is "--" in Excel Formula (SUMPRODUCT) 2

Back
Top