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.

Problem with the NUMBERVALUE formula | Microsoft Community Hub

SergeiBaklan
MVP
Oct 22, 2024
MattSpin

On which Excel platform/version you are?
- MattSpin
  Copper Contributor
  Oct 22, 2024
  SergeiBaklan
  
  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
  - SergeiBaklan
    MVP
    Oct 22, 2024
    MattSpin
    
    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?
SergeiBaklan
MVP
Oct 22, 2024
MattSpin

=IF(is_cat; NUMBERVALUE( INDIRECT(tracked_rank) & INDIRECT(budget_rank)); "")

could work if you are on Excel 2019 or below
MattSpin
Copper Contributor
Oct 26, 2024
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.

Forum Discussion

Problem with the NUMBERVALUE formula