Translation

empty_cells.xhp par_id641535143301636 help.text
English MoQBw
Context English Armenian, Classical (Armenia) (xcl) Actions
empty_cells.xhp
par_id261535142746121
help.text
Results and comments
empty_cells.xhp
par_id941535142746122
help.text
A1: 1<br/>B1: <Empty>
empty_cells.xhp
par_id851535142746123
help.text
Displays 0
empty_cells.xhp
par_id981535142948275
help.text
<variable id="vtrue">TRUE</variable>
empty_cells.xhp
par_id1001535143031604
help.text
TRUE (previously was FALSE)
empty_cells.xhp
par_id201535143064244
help.text
=ISNUMBER(B1)
empty_cells.xhp
par_id421535143064245
help.text
<variable id="vfalse">FALSE</variable>
empty_cells.xhp
par_id681535143124250
help.text
=ISNUMBER(C1)
empty_cells.xhp
par_id211535143124250
help.text
FALSE (previously was TRUE)
empty_cells.xhp
par_id221535143151829
help.text
=ISNUMBER(VLOOKUP(1;A1:C1;2))
empty_cells.xhp
par_id271535143151830
help.text
FALSE (B1)
empty_cells.xhp
par_id861535143183196
help.text
=ISNUMBER(VLOOKUP(1;A1:C1;3))
empty_cells.xhp
par_id371535143183197
help.text
FALSE (C1, previously was TRUE)
empty_cells.xhp
par_id191535143228538
help.text
=ISTEXT(B1)
empty_cells.xhp
par_id251535143279847
help.text
=ISTEXT(C1)
empty_cells.xhp
par_id641535143301636
help.text
=ISTEXT(VLOOKUP(1;A1:C1;2))
empty_cells.xhp
par_id391535143301637
help.text
FALSE (B1, previously was TRUE)
empty_cells.xhp
par_id661535143336012
help.text
=ISTEXT(VLOOKUP(1;A1:C1;3))
empty_cells.xhp
par_id11535143336012
help.text
FALSE (C1)
empty_cells.xhp
par_id661535143373396
help.text
=ISBLANK(B1)
empty_cells.xhp
par_id281535143396581
help.text
=ISBLANK(C1)
empty_cells.xhp
par_id31535143422248
help.text
=ISBLANK(VLOOKUP(1;A1:C1;2))
empty_cells.xhp
par_id871535143422248
help.text
TRUE (B1, previously was FALSE)
empty_cells.xhp
par_id731535143454577
help.text
=ISBLANK(VLOOKUP(1;A1:C1;3))
empty_cells.xhp
par_id941535143454577
help.text
FALSE (C1)
empty_cells.xhp
par_id4217047
help.text
Note that Microsoft Excel behaves different and always returns a number as the result of a reference to an empty cell or a formula cell with the result of an empty cell. For example:
empty_cells.xhp
par_id251535143557533
help.text
Case
empty_cells.xhp
par_id441535143557533
help.text
Formula
empty_cells.xhp
par_id481535143557533
help.text
Results and comments
empty_cells.xhp
par_id311535143557534
help.text
A1: <Empty>
empty_cells.xhp
par_id961535143557535
help.text
Displays 0, but is just a reference to an empty cell.

Loading…

No matching activity found.
Browse all component changes

Glossary

English Armenian, Classical (Armenia) (xcl)
No related strings found in the glossary.

String information

Context
empty_cells.xhp
par_id641535143301636
help.text
Source string description
MoQBw
Source string location
empty_cells.xhp
String age
a year ago
Source string age
a year ago
Translation file
xcl/helpcontent2/source/text/scalc/05.po, string 104