I understand for numbers you can use the n()
function because if you do +n("comment")
to a number it doesn't change the number.
What about string text? I can't use +n()
and add a number to a string.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityI understand for numbers you can use the n()
function because if you do +n("comment")
to a number it doesn't change the number.
What about string text? I can't use +n()
and add a number to a string.
assuming you refer to:
=IF(A1="hello"; 10; 20)+N("add comment")
works=IF(A1="hello"; "x"; "y")+N("add comment")
not workingfor appending a hidden comment to text values you can do:
=IFERROR(IF(A1="hello"; "x"; "y");"add comment")
use it with wisdom