Forum Discussion

yushang's avatar
yushang
Brass Contributor
Mar 18, 2023
Solved

Why ISOMITTED does not work as expected?

Hi guys, Take a look at the following figure, the formula in A1 is =LAMBDA(x,ISOMITTED(x))() What I expected is that A1=TRUE. Many thanks!
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Mar 18, 2023

    yushang 

    TRUE is returned by

    =LAMBDA([x], ISOMITTED(x) )()
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 18, 2023

yushang 

TRUE is returned by

=LAMBDA([x], ISOMITTED(x) )()
yushang's avatar
yushang
Brass Contributor
Mar 18, 2023

SergeiBaklan Thanks, it works. I've never heard of this syntax, could you please tell me where to find the document about it? Thanks again!

Resources