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.
- 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. =IF(is_cat; NUMBERVALUE( INDIRECT(tracked_rank) & INDIRECT(budget_rank)); "")could work if you are on Excel 2019 or below
On which Excel platform/version you are?
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?
