Forum Discussion
Mayukh_Bhattacharya
Aug 31, 2022Iron Contributor
Why does REDUCE Function gives VALUE Error
So I am trying to extract the cities from the string, though I have resolved the issue, with an alternative formula, but my reason to ask this query, is that, I was earlier trying to use the REDUCE()...
Mayukh_Bhattacharya
Aug 31, 2022Iron Contributor
Thank you very much, 😃
Patrick2788
Aug 31, 2022Silver Contributor
- SergeiBaklanSep 01, 2022Diamond Contributor
If a is the text - when not.
- Patrick2788Aug 31, 2022Silver ContributorVery interesting. It looks like a *1 works, too.
- SergeiBaklanAug 31, 2022Diamond Contributor
As a comment, just + before reference/name is enough. Like
=EDATE( +range, n)
=T( +range )