Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
what does "" mean in excell
please help
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
what does "" mean in excell
Chris,
It means nothing, literally a Null value. -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''''Yes'''' below. "chris" wrote: please help |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
what does "" mean in excell
In the context of a formula like =IF(A1="","",A1)
It means if A1 is empty or blank then return a blank. A1 may not necessarily be empty. It could have a formula which evaluates to "" so the above formula would see that as blank. Gord Dibben MS Excel MVP On Tue, 7 Oct 2008 10:29:09 -0700, chris wrote: please help |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
what does "" mean in excell
It's an empty string.
It makes the cell look blank/empty--but it's not. It contains a formula. Lots of people (too many!!) use: =if(a17,"Too many"," ") with the extra space character. But this can cause trouble in cells that check the value in that cell. =if(b1="","looks blank","doesn't look blank") If b1 contained " ", then this formula would return the "doesn't look blank" string. chris wrote: please help -- Dave Peterson |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
what does "" mean in excell
"chris" сообщил/сообщила в новостях следующее: ...
please help "" also means just " but inside the double quotes: =LEFT("John ""JD"" Doe",4) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
want to use a barcode scanner in excell need formula "if" "then" ? | Excel Worksheet Functions | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Why does excell switch my stock symbol "ACN" to "CAN"? | Setting up and Configuration of Excel | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |