Forum Discussion

MattSpin's avatar
MattSpin
Copper Contributor
Oct 22, 2024

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.  
Excel
Formulas and Functions
  • MattSpin's avatar
    MattSpin
    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.
SergeiBaklan's avatar
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

Resources