Forum Discussion
Solved
Problem with the NUMBERVALUE formula
Hi, this formula, which seems correct to me, gives me the #VALUE! error. I cannot find why it is not working, any idea on where to look? Thanks fot the help.
- I solved it by my self, I used the original formula but i changed the excel settings and told the program to use the default system separators instead of "." and it worked.
I do not know why it worked, if someone knows please enlighten me.
Best regards,
Matteo.
Hi,
Thanks for the reply,
This is the version I'm currently running:
Microsoft® Excel® for Microsoft 365 MSO (Version 2409 Build 16.0.18025.20160) 64-bit
In any case you shall use INDIRECT, but on 365 formula will return #SPILL error. Could you please clarify what is under is_cat, tracker_rank, etc names?
Hi,
I applied the INDIRECT formula and the error code changed in #REF!
Please see screenshot for the names content.
Thank you for your time.