Forum Discussion
Why does REDUCE Function gives VALUE Error
Okay, but you said an error is on Excel Desktop and you don't use Excel for web
If a is the text - when not.
- Very interesting. It looks like a *1 works, too.
As a comment, just + before reference/name is enough. Like
=EDATE( +range, n)
=T( +range )
- Thank you very much, 😃
Mayukh_Bhattacharya , you are welcome. Without knowing your environment I don't know what it was as well.
Nothing to do to close. If you have no more questions or comments related to the topic do nothing here. And you are welcome to open new thread if you have another new questions to community.
- Sir, even though its working now, but I am not able to figure what was the issue, anyways when its working, better not to take any more stress on it. Thank you very much for your time patience and effort. Sir how do i close the post.
Glad to know you sorted this out, thank you for the update.
SergeiBaklan Sir, strange same formula is working now, but not able to understand why it was not working then
SergeiBaklan Sir see this image its working but not working for those strings which I posted earlier, also MS Support guy was not able to help.
- Ok Sir, I found out, that I can use REDUCE() Function anywhere, i.e. I have used that specific formula in other workbooks and as well as in new workbook as well, but it is not working for this specific texts strings. For those US Addresses
