Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
what does "" mean in an excel formula
what does "" mean in an excel formula e.g. =if(c43="","", +sum
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |